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!
Tahreem24
Super User
Super UserAnonymous ,
No, I am getting the 9 for 2019 and 12 for 2018. Refer below screen shot.
Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!
So it may helps other!
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
Anonymous ,
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 !
is your monthnumber and year a date field ?