Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello guys, I have a the last two digits of the year and is in text format how can I make it 2020,2019 and in date format?
Solved! Go to Solution.
@Kalachuchi , Aumming you have year values like 19
a new column in date format
Date([Year]1,1)
or
date(2000+[Year],1,1)
in yyyy format
year(Date([Year]1,1))
or
year(date(2000+[Year],1,1))
@Kalachuchi , Aumming you have year values like 19
a new column in date format
Date([Year]1,1)
or
date(2000+[Year],1,1)
in yyyy format
year(Date([Year]1,1))
or
year(date(2000+[Year],1,1))
User | Count |
---|---|
94 | |
79 | |
75 | |
64 | |
60 |
User | Count |
---|---|
106 | |
98 | |
76 | |
63 | |
61 |