Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    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! 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks I changed to a whole number and it worked !

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Great Anonymous !

 

I will really appreciate your KUDOS/Thumbs up! ðŸ˜Š

Good Luck!