HOTSPOT
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Box 1: TOPN
TOPN returns the top N rows of the specified table.
Box 2: SUMMARIZE
SUMMARIZE returns a summary table for the requested totals over a set of groups.
Box 3: DESC
Sort in descending order.
It is last in the TOPN command.
TOPN syntax:
TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]…])
Latest DA-100 Dumps Valid Version with 114 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund