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.
I have a data set that has month over month values so I want the months to be columns instead of rows. I have values for all rows, but when I unpivot- I get nulls with some where there should be a number. I only pulled in the data I needed and made sure the format type was correct. Has anyone else had this issue?
Hi @yarelbelanger17 ,
Whether your problem has been resolved?
Best Regards
Rena
Can you go to visualization and create a pivot in matrix and and check the values. I doubt, mutiple rows has been created during unpivot. Ans some of them have 0 values.
Hi @yarelbelanger17,
Could you please provide the related table structure and some sample data in this table? And please also provide the applied step script for Unpivot(see below screenshot). Thank you.
Best Regards
Rena
Provide some sample data.. I could not simulate the error. I have seen it in the past and vaguely remember it was a datatype issue. Maybe convert them to text and unpivot..
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |