Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi all,
Creating a report using table visual with lots of column used.In that i need to use a rank function like sql query which is showed below.
Rank() OVER(PARTITION BY table."policyno"
ORDER BY table."Loc_no" DESC ,table."vers_no" DESC
Is it possible?
Solved! Go to Solution.
@NISHA_S , Try a Rankx as a new column
ranxk(filter(Table, [policyno] = earlier([policyno]) , calculate([Loc_no] & "-" & [vers_no]) , , desc, dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
@NISHA_S , Try a Rankx as a new column
ranxk(filter(Table, [policyno] = earlier([policyno]) , calculate([Loc_no] & "-" & [vers_no]) , , desc, dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.