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.
Hello,
Please advise how can I change the columns definition from text to date.
In the exist columns the values appears as Jan Feb... in text format and the years as 2017 2018 in text or decimel number format.
Thank you,
Alona
Hi @alona,
Assume sample data looks like below:
You can create a calculated column below:
Date = DATE('Table1'[Year],SWITCH([MONTH],"Jan",01,"Feb",02,"Mar",03,"Apr",04,"May",05,"Jun",06,"Jul",07,"Aug",08,"Sep",09,"Oct",10,"Nov",11,"Dec",12),1)
Best Regards,
Qiuyun Yu
Thank you very much. It was very helpful.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |