Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
In power query I would like to unpivot my table based on a condition: unpivot all columns except those that start with "IP_address" or "Please state your".
Is this possible?
Thank you
Solved! Go to Solution.
Hi @nickzizos,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi @nickzizos,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi @nickzizos,
We can select these columns with "Ctrl", then use "Unpivot other columns". Please have a try.
Best Regards!
Dale
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
91 | |
84 | |
69 |