How to change the Date Format from MM/DD/YYYYY to DD/MM/YYYY ?

[admin11]

Hi All

My SALES_I table date format is MM/DD/YYYY

My SALES_T table date format is DD/MM/YYYY

My i know how to change the SALES_I table date format is MM/DD/YYYY to DD/MM/YYYY ?

My PBI file :-

https://www.dropbox.com/s/27r10hc73bijui7/PBTI_V050.pbix?dl=0

Paul

[bcdobbs]

In the background power bi imports dates as integers. You then can choose the display format:

or in the model view you can set custom formats:

[admin11]

@bcdobbs 

Thank you for sharing. I have try to set the date format as per your image, it does not change . 

Issue is when i try to append both table into 1 , the date format have 2 different type. ( I have also try to use PQ to change the field to date , many row get error , I also try to change by change type with Locale. it also does not work.

[negi007 · Accepted solution]

@admin11 in this case I can see that your data is in date format(MM/DD/YYYY) already in second table so you need to change the date format 

However, your data in first table is not in the date format(dd/mm/YYYY) so you wont be able to perform date calc/time inteligenice calc so in powerquery window you can simply change the format like below

this is the format you have 

right click on your date column, you will get option to add column from examples. you type the first two values in the format you want to have the data. power query will format the data for rest of the records

then you can change the format the data to date format

now you data is in the date format in both the tables.

[admin11]

@negi007 

Thank you very much for your sharing . Your explanation is very clear. i learn one more new thing,

Paul