Change Date format from dd/mm/yy to mm/dd/yy

[Paridhisharma]

HI,

how can i change date format from mm/dd/yy to dd/mm/yy?

i checked some of the solutions about splitting the column, and merging them as mm/dd/yy.

Is there any other way to do it. 

[v-huizhn-msft]

Hi @Paridhisharma,


Please mark the right/helpful reply as answer. More people will learn new things here.  If you haven't, please feel free to ask.

Thanks,
Angelia

[Thyago_Rezende]

Hi @Paridhisharma,

Did you try the FORMAT function in dax? 

https://msdn.microsoft.com/en-us/library/ee634924.aspx

[Vvelarde · Accepted solution]

@Paridhisharma

Hi, in Query Editor,Right Click in the column -  Change Type-Using Locale - Select the Type (Date Time) and Select the Locale.

Regards

Victor