Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Month Format with TODAY date

Hello, I have an issue. How to automatically calculate the name of the month that was 6 months ago and will be in 6 months. I want to show the calculated month names on the axis in place of red lette...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Try this:

    Previous 6 Month = FORMAT(EOMONTH(TODAY(),-6),"mmmm")

Post 6 Month = FORMAT(EOMONTH(TODAY(),6),"mmmm")
dnargade95's avatar
dnargade95
New Member
3 years ago

you can do that with following steps.

first create month number column it will give you 1 to 12 value.

then apply if /switch function to create dax if month number is 1 then jan.

go upto 6