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

 

You have to have the field selected in the menu, or the column selected in the data view,  Then the Sort By Column should offer a dropdown.

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

really odd, still doesn't work.