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!
Now in my data set I have a column to enumerate the weeks (in portuguese week = semana) and a column for each day of the week (in portuguese: segunda = monday, terça = tuesday, quarta = wednesday). How can I tranform the dataframe above in just three columns with "semana" (the column I already have), day of week and the float value?:
I did some ilustration to explain what do I want:
Please, I appreciate any help.
Thanks, regards from BR.
Solved! Go to Solution.
UNpivot the days columns in Power Query. I think it's what you are looking for
UNpivot the days columns in Power Query. I think it's what you are looking for
Was almost this, but your answer was usefull to me to find the solution.
Thanks a lot!
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |