Forum Discussion
DAX Help Required
I would like to know how can I get the following results using DAX or anything else in Power BI: I am using following example to explain the scenario and the desired results: I have a table c...
Thank you for looking into this. I have already given the desired table structure. I am pasting it again. The following table should show the results of Top 5 Companies for each Agent. Agents will be selected via Slicer in a dropdown list
| 2018 | 2019 | 2020 | 2021 |
Company A | 56 | 76 | 78 | 98 |
Company B | 35 | 46 | 24 | 15 |
Company C | 46 | 67 | 78 | 56 |
Company D | 34 | 36 | 47 | 58 |