How to covert date format 04/09/2019 to 09 April 2019 ?

[admin11]

Hi All

After i import CSV data to PBI , my date format is mm/dd/yyyy , how to change to dd month yyyy ?

I have try to use the change type with location , but i cannot get it :-

Hope some one can advise me.

Paul

[themistoklis · Accepted solution]

@admin11 

Using Power Query Add New Column and insert the following formula. Amend as necessary

Conditional Column = Text.Middle(AR_Invoice_Date, 5, 2) &"/"& Text.Start(AR Invoice Date,2) & "/" & Text.End(AR Invoice Date,4)

Then Right Click and Convert it to Date