Forum Discussion
Solved
Top month per category
Hello, I'm trying to create a measure to calculate the top month per ID per country baesd on the value. Desired output: ID Country Top Month A UK June B UK October A US July ...
Try thie MEASURE
Measure = CONCATENATEX ( TOPN ( 1, Table1, CALCULATE ( VALUES ( Table1[Value] ) ), DESC ), [Month] )
Try thie MEASURE
Measure =
CONCATENATEX (
TOPN ( 1, Table1, CALCULATE ( VALUES ( Table1[Value] ) ), DESC ),
[Month]
)