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.
I am looking to convert a hardcoded date ex : "1900-1-1" to datetime. How can i do it using dax. Basically I am using something like below.
IF(Condition,table(column)(datetime) ,"1900-1-1")
I am getting error because 1900-1-1 is considered as text and my true condition column in IF is datetime. How to handle this in DAX ? Thanks for looking
hI,
USE FORMAT function in dax to achieve your goal. however, you can use Edit quries (on the top tab)
and then in there, select the column you like to change the data type and then go to tansform (on top tab).
there you will find a option called data type. change this you either Date/Tine or Date according t your requirement
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 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |