Forum Discussion

UditJ's avatar
UditJ
Icon for Helper III rankHelper III
2 years ago
Solved

Sorting Year-month sequentially

Using below formula to calculate year-month: Year-Month = FORMAT('Reporting.Digital'[Date],"MMM YYYY") and sorting this Year-Month on Month Number and below is the output i am getting: Des...
data protection
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    HI UditJ 

    Please create another column

     

    SortOrderYearMonth = 
Year(Table[Date])&Month(Table[Date])

     

    Select the Year-Month column and change Sort by to new column


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

HI UditJ 

Please create another column

 

SortOrderYearMonth = 
Year(Table[Date])&Month(Table[Date])

 

Select the Year-Month column and change Sort by to new column


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin