Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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