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.
Hi all,
I have got data that have 12 columns for months with the abbreviated month name - Jan, Feb, Mar etc. Previously, I just did not bother and manually changed these to be 31.1.2019, 28.2.2019 etc., than did "unpivot columns".
But as I have more and more reports, this manual approach has become inefficient, would you be able to advice me how to automate this process?
Thanks,
Solved! Go to Solution.
Unpivot the columns first, then append “-2019” to the month names, then convert them to dates
Unpivot the columns first, then append “-2019” to the month names, then convert them to dates
Got it, -> Add Columns, Format, Add Suffix
Sorry for my ignorance, the append "-2019", how could I do it? Still in the editor, I presume, right?
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |