Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I´ve the Table1, and I need to create a new calculated table "Final Table" ( only the name of the camp Prod), but with the top 1 for each Region:
Thanks.
Solved! Go to Solution.
@Alexo3627 , Ideally you should use Rank/TOP/index and a visual table.
but for calculated table try like
selectcolumns(filter(addcolumns(Table, "_Rank", Rankx(filter(Table, [Region] = earlier([region]) ), [Sales],,desc,dense) ),[_Rank] =1), [Product])
Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Hi,
Why do you want only 1 column in the Final Table. Wouldn't you also want to see the Product and Region?
@Alexo3627 , Ideally you should use Rank/TOP/index and a visual table.
but for calculated table try like
selectcolumns(filter(addcolumns(Table, "_Rank", Rankx(filter(Table, [Region] = earlier([region]) ), [Sales],,desc,dense) ),[_Rank] =1), [Product])
Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
User | Count |
---|---|
90 | |
84 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |