Date Formatting - Data Tab

[Anonymous]

Hi, I have done an import into Power BI for a data source and have had to create a query to =left (8) to extract the date as it has come through as a duplicate. This has given me the 'date' i need but in a text format. When i go to Modelling and change it to a Date format, it completely changes the date. Driving me round the bend! screenshots below;

- Using the =Left function, you can see the Date now is correct;

- Now within modelling i change the column to a 'Date', it looks like this;

Anyone know how to solve this??

Thanks 

Keith

[FrankAT]

Hi @Anonymous 

your date is in german date format (dd-mm-yy). Use the option to change type with local (see figure).

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

Thanks for the quick reply! 

Am i just being daft and looking in the wrong area? but this is the only options to change the type i have under modelling??

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can create a calculated column and change it to date type:

Date2 = LEFT('Table'[Attribute],8)&"20"

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

Best Regards,

Dedmon Dai

[FrankAT]

Hi @Anonymous 

my first reply refers to changing data type in Power Query. If you want to use dax than

1. Select Model View.
2. Select the data field and open properties pane.
3. Change Date time format to Custom.
4. Type the desired date format and press Enter.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)