Forum Discussion

Nihed's avatar
Nihed
Icon for Helper III rankHelper III
4 years ago
Solved

Last month

Hello, I have date table, then I create a new column call Month Name using  Month Name = FORMAT('Date'[Date],"MMMM") And I have Month Number for sorting this month name become a proper sorting. I...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Nihed ，

    If the Month Number column is of text type, the September will be the largest as you described.

    Change the Month Number data type to Whole number, it will be sorted numerically from smallest to largest.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Nihed 
can you try this measure?
Max Month = CALCULATE( Month Name, Month Number = MAX(Month Number))

  • Nihed's avatar
    Nihed
    Icon for Helper III rankHelper III
    4 years ago

    what do you mean by Month Name lease?

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      4 years ago

      Nihed . I think Aditya Suggested the month name column you created

       

      a measure Like

      maxx(filter(all(Date), Date[Month Number] = max(Date[Month Number])), Date[Month Name])