Forum Discussion
mysho999
6 years agoFrequent Visitor
TOP N
Hi i need advice. I have a spreadsheet of data. I would need to make two tables: The first table will show the TOP 2 department by Duration The second table will be the top1 Code and Co...
amitchandak
6 years agoSuper User
mysho999 , For TOPN Refer
For Rank Refer these links
https://databear.com/power-bi-dax-topn-function/
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale