Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello to you that reads this!
I'm having a hard time with this situation, any suggestion will be very appreciate!
This dataset I'm working on came with the sales values splitted in "month columns", like this:
How is the best way to work with it? I can't filter it by month, I can't work with date intelligence 😢 .
I guess the best way is to transform this columns into rows, kind like this:
Am I right? If so, PowerBI does this? The "Columns to Row" option didn't seems to work like this.
Best regards! Stay safe.
Vinicius.
Solved! Go to Solution.
That will normalize the data for you.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingGreat @viniciusz - I could tell you knew what to do when you were looking for a columns to rows transformation, but just needed a bit of help on how Power Query does that. The Unpivot is one of the most powerful and most common transformations I use.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@viniciusz , You need to unpivot the table in this case.
https://radacad.com/pivot-and-unpivot-with-power-bi
https://youtu.be/oKByyI09Bno
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
That will normalize the data for you.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |