cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Member

## Convert whoel number to Date

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

1 ACCEPTED SOLUTION

Accepted Solutions
Established Member

## Re: Convert whoel number to Date

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

5 REPLIES 5
Established Member

## Re: Convert whoel number to Date

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

Member

## Re: Convert whoel number to Date

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

Established Member

## Re: Convert whoel number to Date

Hi @sabeensp ,

There are two Solutions in this post.

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

Thanks,

Tejaswi

Member

## Re: Convert whoel number to Date

@tejaswidmello  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

Established Member

## Re: Convert whoel number to Date

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

## Helpful resources

Announcements

#### New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)