Forum Discussion

SachinC's avatar
SachinC
Icon for Helper V rankHelper V
9 years ago

Date Formula for MMM

Hi, I have a Date field which I broke down using DAX for Day = day({fieldname]), Month = month([fieldname]) and Year = year([fieldname]).  I now want to format my numerical months in my charts to MM...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi SachinC

 

Please try adding these two columns to your table.

 

MonthName = FORMAT({fieldname},"MMM YY")

MonthID = INT(FORMAT({fieldname},"YYYYMM")

The first column should be formatted the way you want, but I would use the Sort by column feature to have it sorted by the other column.  

 

If it were me, I'd be doing this in the Date/Calendar table :)