Forum Discussion
Max Month Number per Year
Hello All, I'm wanting to return the max monthnumber for each year. For the example below 2018 would return 12 AND 2019 will return 9. I will then be using that calculation to divide a measure to...
Anonymous ,
Create a below meaure to get Max monthnumber.
Max Month Number = CALCULATE(Max(Sheet9[MonthNumber]),ALLEXCEPT(Sheet9,Sheet9[Year]))Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!
| 1 | 2018 |
| 10 | 2018 |
| 11 | 2018 |
| 12 | 2018 |
| 6 | 2018 |
| 7 | 2018 |
| 5 | 2018 |
| 9 | 2019 |
| 4 | 2019 |
| 1 | 2019 |
| 2 | 2019 |
| 3 | 2019 |
| 5 | 2019 |
nvprasad
Solution Sage
Solution SageHey,
Here is two forumulas you can use either.
1.Maxmonth = MAX('Table'[Number])
2.MaxMonth = CALCULATE(MAX('Table'[Number]),FILTER('Table','Table'[Year]=SELECTEDVALUE('Table'[Year])))
Thanks,
Venkata Nalla