Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Has anyone else come across this problem or varying formats on dates in the same column?
I have a column of text, some with dates in, some with "TBC" and "N/A", so I've created a new column extracting into a date format anything with a LEN > 5.
As an example, the text "25/04/2018" extracts to this new column as "25 April 2018"
but "12/03/2018" extracts as "03 December 2018"
I've checked the Excel source formatting and there is no issue there so I'm a little stuck at the minute.
Solved! Go to Solution.
@Anonymous,
You may use DATE Function to add a calculated column.
Column = DATE ( RIGHT ( Table1[Column1], 4 ), MID ( Table1[Column1], 4, 2 ), LEFT ( Table1[Column1], 2 ) )
Hi @Anonymous
I came across the exact same issue. Reformatting the data type to 'Date' via the Modeling tab didn't work for me.
However, going into 'Edit Queries' and transforming the data type here from 'Any' into 'Date' displayed the correct format across the whole column of dates.
@Anonymous,
You may use DATE Function to add a calculated column.
Column = DATE ( RIGHT ( Table1[Column1], 4 ), MID ( Table1[Column1], 4, 2 ), LEFT ( Table1[Column1], 2 ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |