Exponential number instead of Date (Jira)

[Anonymous]

Hi,

I have the following columns: 

I have changed the regional configuration to English US.

Any ideas? 

Thanks

[v-alq-msft]

Hi, @Anonymous 

If you take the answer of someone, please mark it as the solution to help the other members who have same problems find it more quickly. If not, let me know and I'll try to help you further. Thanks.

Best Regards

Allan

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I'd like to suggest you convert datetime to date in Query Editor using M codes. For furhter information, you may refer the following link.

https://community.powerbi.com/t5/Desktop/Convert-DateTime-into-Date-in-Query-Editor-using-M-function/m-p/711511

Best Regards

Allan

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

[amitchandak]

Try to change the data type to Date and format to the required one.

Related screen shot. not for date.

[Anonymous]

The problem is, when I want to change it to Date type, it sohws me an error:

[amitchandak]

Can you check all the dates in the same format?