topic Re: Date format issue in Desktop

Date format issue

cham — Fri, 03 May 2019 05:26:29 GMT

Hi,

I want to change the date format "Month/Date/Year" into "Date/Month/Year" format in Power BI. How can i do that.

I have an excel sheet with date column it includes all the dates as "MM/DD/YYYY" format i cannot change it in excel. Howa can i change that in Power BI.

Because when i upload that excel sheet into Power BI date column is getting as "text" I cannot change it to date field in Query Editor.

Regards,

Cham

Re: Date format issue

Anonymous — Fri, 03 May 2019 05:36:34 GMT

Create a one variable and insert a date function and then convert the format(Date/Month/Year) according to your requirement in the Power BI.

Regards

Rohit

Re: Date format issue

cham — Tue, 07 May 2019 22:49:55 GMT

Do I need to add a column an put a "format" function in the report?

Re: Date format issue

Anonymous — Wed, 08 May 2019 05:33:33 GMT

Hello Cham,

Yes.please put date fundtion and mention in which format you required.

Regards

Rohit

Re: Date format issue

cham — Wed, 08 May 2019 06:10:13 GMT

I export CSV file into Power BI. But some dates are showing as Error. Can I know the reason for that?

Also is this formula correct? Date = FORMAT(Sheet1[Date],"dd""mm""yyyy")

This is not working for me

Re: Date format issue

Anonymous — Wed, 08 May 2019 06:15:27 GMT

Hello Chasm,

Please cross the check the function formula and data appearing the excel sheet .whehter it is same format as above or different format the date is appearing..

Regards

Rohit

Re: Date format issue

v-juanli-msft — Thu, 09 May 2019 09:02:34 GMT

Hi cham

This formula should be correct.

Date = FORMAT(Sheet1[Date],"dd/mm/yyyy")

It is a DAX formula used in a calculated column.

Is the column with error your original data or the modified data with any transformation?

Could you share me with data in your excel for analysis?

Best Regards
Maggie