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.
buttercream Well, you could put Month and Product in a table visual and then simply:
Measure = COUNTROWS( 'Table' )
Or you could create a table like:
Table1 = SUMMARIZE( 'Table', [Month], [Product], "Count", COUNTROWS( 'Table' ) )
That gives me the count for each product for each month. How do I get the top product in each month only? Sep'24 should only show A with 4.