Forum Discussion
HardCoded date to datatype Date conversion using dax.
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...
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