Forum Discussion
badger123
Resolver I
Resolver ITop 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 |
| B | US | December |
Table:
| ID | Country | Month | Value |
| A | UK | January | 10 |
| A | UK | February | 10 |
| A | UK | March | 10 |
| A | UK | April | 10 |
| A | UK | May | 10 |
| A | UK | June | 20 |
| A | UK | July | 10 |
| A | UK | August | 10 |
| A | UK | September | 10 |
| A | UK | October | 10 |
| A | UK | November | 10 |
| A | UK | December | 10 |
| B | UK | January | 10 |
| B | UK | February | 10 |
| B | UK | March | 10 |
| B | UK | April | 10 |
| B | UK | May | 10 |
| B | UK | June | 10 |
| B | UK | July | 10 |
| B | UK | August | 10 |
| B | UK | September | 10 |
| B | UK | October | 20 |
| B | UK | November | 10 |
| B | UK | December | 10 |
| A | US | January | 10 |
| A | US | February | 10 |
| A | US | March | 10 |
| A | US | April | 10 |
| A | US | May | 10 |
| A | US | June | 10 |
| A | US | July | 20 |
| A | US | August | 10 |
| A | US | September | 10 |
| A | US | October | 10 |
| A | US | November | 10 |
| A | US | December | 10 |
| B | US | January | 10 |
| B | US | February | 10 |
| B | US | March | 10 |
| B | US | April | 10 |
| B | US | May | 10 |
| B | US | June | 10 |
| B | US | July | 10 |
| B | US | August | 10 |
| B | US | September | 10 |
| B | US | October | 10 |
| B | US | November | 10 |
| B | US | December | 20 |
Try thie MEASURE
Measure = CONCATENATEX ( TOPN ( 1, Table1, CALCULATE ( VALUES ( Table1[Value] ) ), DESC ), [Month] )
1 Reply
- Zubair_Muhammad
Community Champion
Try thie MEASURE
Measure = CONCATENATEX ( TOPN ( 1, Table1, CALCULATE ( VALUES ( Table1[Value] ) ), DESC ), [Month] )