Forum Discussion
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...
Hi mysho999 ,
For the first table, it's dynamic.
For the second table, I hard-code it to calculate the top 1 for ENG and Maintenance department as you said.
If you want to change it, you need to change the label in the DAX.
Aiolos Zhao
Hi Anonymous
1. I would need to add a filter by date (TOP 3 department as well as Code, code de ... will change based on time range)
2. Probably more complicated ... In table 2 I only need to show data based on the TOP 3 department. (for example: if in table 1 there is a top three x, y, z then in table 2 I need to visualize TOP1 only for x, y, z. If TOP 3 in the first table changes, TOP 1 in the second table will also change.)
2. Probably more complicated ... In table 2 I only need to show data based on the TOP 3 department. (for example: if in table 1 there is a top three x, y, z then in table 2 I need to visualize TOP1 only for x, y, z. If TOP 3 in the first table changes, TOP 1 in the second table will also change.)
Source: https://drive.google.com/drive/folders/1cQF3zhHtCLjaFDg7CLSyerMW1qtWbdz6?usp=sharing
Thank you 1000 times