Forum Discussion
Solved
RankX help
I'm trying to find the product with the highest number of rows for each date. What would be the best way to change: This table: Month Product Sep'24 A Sep'24 B Sep'24 A Sep'2...
Hi,
PBI file attached.
Hope this helps.
Hi, buttercream
You can also try the following DAX expressions to create a new table
TopProductTable =
VAR _vtable = SUMMARIZE(
'Table',
'Table'[Month],
'Table'[Product],
"_Count", COUNT('Table'[Product])
)
RETURN
SELECTCOLUMNS(FILTER(ADDCOLUMNS(_vtable,"_A",MAXX(FILTER(_vtable,'Table'[Product]=EARLIER('Table'[Product])),[_Count])),[_Count]=[_A]),'Table'[Month],'Table'[Product],[_Count]
)
Here is my preview:
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly