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.
Hi guys, for some reason my files consist of order dates in the form of a whole number such as this 200910 If converted correctly, it should read as 2020 - 09 - 10 or September 10th 2020.
The problem is I have trouble converting this into a date. Any suggestions of how to do so easily in dax?
@cdawidow , My advice would be covert it into date column like
Column
Date = date(quotient([order dates],100), Mod([order dates],100),1) //whole number
Date = date(left([order dates],2), right([order dates],2),1) // text
you can use the format from the column menu. Or format function to get desired format
@cdawidow - Try:
Date Column =
MID([Column],3,2) & "/" & RIGHT([Column],2) & "/" & LEFT([Column],2)
then convert that to a date.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |