I'm working on a data file that has details of different types of deductions for example pension contributions, taxes etc. Each of this deductions is a column in the data file with their respective values. I would like to create a category column that groups different deduction types in one class for example columns relating to national insurance contributions and tax will be categorised as tax deductions etc. See some dummy data snapshot
Hi @Anonymous
I think you will achieve by using unpivot option in Power Query editor.
If you see dummy data as mentioned below..
Then you need to perform Unpivot action by selecting columns. Now you'll get output as mentioned below.
Is this you are expecting?
Hi @Anonymous
I think you will achieve by using unpivot option in Power Query editor.
If you see dummy data as mentioned below..
Then you need to perform Unpivot action by selecting columns. Now you'll get output as mentioned below.
Is this you are expecting?
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
