Forum Discussion
Solved
Table with Ultime N
Dear All I have a table with data with following information Aging and FW (fiscal week) Considering that I have about 100 value of Aging for each FW. I need to view only the first 5 Top aging ...
Hi riccardotesti76 - If you prefer to pre-calculate the filtered data, you can create a calculated table
Top 5 Aging Latest FW =
TOPN(
5,
FILTER(
'YourTable',
'YourTable'[FW] = MAX('YourTable'[FW])
),
'YourTable'[Aging],
DESC
)you can use this table in your visualization, Hope this works
Hi riccardotesti76 - If you prefer to pre-calculate the filtered data, you can create a calculated table
Top 5 Aging Latest FW =
TOPN(
5,
FILTER(
'YourTable',
'YourTable'[FW] = MAX('YourTable'[FW])
),
'YourTable'[Aging],
DESC
)
you can use this table in your visualization, Hope this works
Fantastic!!! You suggested a formula that I can customized for several issue!!!
Thanks