Forum Discussion
Date format issue
Hi All, facing date format issue like one file (MM/DD/YY) another one file contains (DD/MM/YY) how to change as a same format in powerbi. examble :
In Power Query, right-click the column and 'Change Type' ->using Locale, and you pick the date format you want to transfer from (for example, UK or US).
From the picture I think you have appended the 2 files and the column is text so you need to do this before appending the 2 files.