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!
This is my calculation:
Max Month Number = CALCULATE(MAX(FACT_AreaExpenses_PBuddTable[Month]),ALLEXCEPT(DIM_Calendar,DIM_Calendar[Year]))
The year is coming from another table:
Tahreem24
Super User
Super UserAnonymous ,
Both fields are in numeric form(Whole number). You didn't mention about the Year is coming from different table. FOr this make a proper relationship betweeb those table.
Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!
Thanks I changed to a whole number and it worked !
- Tahreem24
Great Anonymous !
I will really appreciate your KUDOS/Thumbs up! 😊
Good Luck!