Convert whoel number to Date

[sabeensp]

Hello I have a column with Whole number like 20190106, when I try to convert that to Date it give me an error. How can I covert above whole number to YYYY/MM/DD format?

Thanks

[Anonymous]

Hi @sabeensp ,

Take a look at this post. The issue is already resolved in this post.

https://community.powerbi.com/t5/Desktop/date-from-yyyymmdd-stored-as-whole-number/td-p/92689

Thanks,

Tejaswi

[sabeensp]

@Anonymous  M code not working for me somehow, when I add a new calcualted column. Is there another way?

[Anonymous]

Hi @sabeensp ,

There are two Solutions in this post.

Did you try the second one. Hope that works for you.

Thanks,

Tejaswi

[Anonymous · Accepted solution]

Hi @sabeensp 

Did you try adding M code like this?

Or you can also try this new column:

Column = Date(Left([data],4),Right(left([data],6),2),right([data],2)

and then change the data type of new column to Date

Let me know if thsi works.

Thanks,

Tejaswi

[sabeensp]

@Anonymous  problem with the 2nd solution is that I have over 15 Date columns, divide them into YY, MM, DD would result in 45 columns. I was hoping for some DAX formula to convert