Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
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.      
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    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.

     

o59393's avatar
o59393
Post Prodigy
6 years ago

Hi 

 

Where do I have to paste that?

 

As an added custom column?


Thanks!

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

That was the code behind the query. You would create a blank query and then paste that code into Advanced Editor. I think I created that code using Add Column From Examples.