How to create date from 201902 to 02/01/2019 using dax or power query?

[Anonymous]

Hi,

I have date column and the value of the column is : 201902 which is YYYYMM format. when I load the value in power bi, it shows that data type is shoowing as Text.

Now I have to create date from this and format should be MM/DD/YYYY.

Please suggest what to do now?

[Mariusz · Accepted solution]

Hi @Anonymous 

You can add custom column in query editor.

Please see the code below

=Date.FromText([YourColumn] & "01")

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

https://docs.microsoft.com/en-us/dax/datevalue-function-dax

The datevalue(DateColumn) should work here. It turns text based date into datetime values.