Forum Discussion
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 letters.
Could you help me with this?
Anonymous Try this:
Previous 6 Month = FORMAT(EOMONTH(TODAY(),-6),"mmmm") Post 6 Month = FORMAT(EOMONTH(TODAY(),6),"mmmm")
3 Replies
- Greg_Deckler
Community Champion
Anonymous Try this:
Previous 6 Month = FORMAT(EOMONTH(TODAY(),-6),"mmmm") Post 6 Month = FORMAT(EOMONTH(TODAY(),6),"mmmm")Greg_Deckler it is perfect solution! Thank you very much!
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
