Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all
I want to pivot my data by group and maximum data. See suggested solution below:
I'm not sure this is the correct approach to do it, but it was the one that seemed most logical to me.
Not
Solved! Go to Solution.
Hi,
You should be able to do this with Power query. Refer the Screenshots below.
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
Hi,
You should be able to do this with Power query. Refer the Screenshots below.
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
Thanks for you suggestion
I picked the pivot button instead of unpivot as that is the operation I am looking for.
I get this for the first step, which is correct:
I do however get the error message when I pivot the data:
"Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=[Type]"
I have looked through my data but there are no Null values.
Can you help?
hi, @ChristianRHouen
You could try use Pivot column as below:
Result:
you could also add a new custom name that is ""Software" & [ID_software]" and use it for pivot column.
here is sample pbix file, please try it.
Best Regards,
Lin
Hi,
You will need to select the list of Columns that you want to Unpivot. Also, Check if the columns have null values.
If you are still unsure about this, then Share this PBIX with me and I shall complete it for you.
Best Regards,
Vignesh M
If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |