Forum Discussion
Solved
Rank based on dates (top 5)
Hi all, I have this table: Country Company CountCo CountB System date Brazil M 1 1 09/01/2023 Brazil P 2 2 ...
Ibendlin,
Thank you for your suggestion.
I finally solved creating a table like this:
Table_aux =SUMMARIZE(table,ROLLUP( table[Country.], table[Company.], table[System date.]),"@Count Company", COUNT(table[Company.]),"@Count Code", COUNT(table[Code.]))Then, i use Top 5 in [System date] filter and adding a relative date in another [System date] filter in Filter Section.Best!
Ibendlin,
Thank you for your suggestion.
I finally solved creating a table like this:
Table_aux =
SUMMARIZE(table,
ROLLUP( table[Country.], table[Company.], table[System date.])
,"@Count Company", COUNT(table[Company.])
,"@Count Code", COUNT(table[Code.])
)
Then, i use Top 5 in [System date] filter and adding a relative date in another [System date] filter in Filter Section.
Best!