Forum Discussion
Solved
Date format
Hi all How can I convert a date in format "Apr 01 2019" to "April 2019" for example and using power query? https://1drv.ms/u/s!ApgeWwGTKtFdhjOrLr9_z4xQWZca?e=KpC6mb Thanks.
o59393 ,
You have to go to Transform Data/Edit Query and use the Custom Column option.
In Dax , you can try like
format(DATEVALUE("Apr 01 2019"),"MMMM-YYYY")If it a static value you can use in measure too. Else in measure use some aggregation.
