Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I have a year column in a table where if I change its data type to date format it changes all the year values. I tried to make that year column dd.mm.yyyy format by using below DAX but I can’t change data type here to date format.
DATE = "1.1."&'Export'[Year Built, Year]
I need to make that year column as 1.1.yyyy format and data type should be date as I want to use time intelligence function. Could you please help me to solve this problem?
BR,
Fahid
Solved! Go to Solution.
@Fahid create a calculated column using following formula > Then change Date Format as highlighted in below screenshot
Column = DATE(Sheet1[Year],1,1)
If I misunderstood your requirement, please elaborate your requirement.
@Fahid create a calculated column using following formula > Then change Date Format as highlighted in below screenshot
Column = DATE(Sheet1[Year],1,1)
If I misunderstood your requirement, please elaborate your requirement.
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |