Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Creating a payroll

I have a problem with creating my payroll
At the end I want to get the following table:

 

PAyroll.JPG

My data has been imported into the program in this format:

Excel.JPG

 

The problem has always been that I do not have my own table in which the desired terms (Sales Turnover, Surcharge C, etc.) are associated with the values.


How do I get it now that I choose the column header as a row heading without first changing it in the Power Query Editor? I can not find a visual that offers me this feature.


Another possibility would be to create my own table in which I create a list (Sales Turnover, Surcharge C, etc.) and then link them to values from another table.

 

HIHI.JPG

 

Best regards,

Frank

1 REPLY 1
v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

My original data table is like this:

e4.PNG

Then, calculate :

e5.PNG

GS = P3[ST] + P3[+SC]
GS-b = P3[GS] - P3[-BC]
KF1 = P3[GS-b] -P3[-M-C] 
KF2 = P3[KF1] - [-F-C] - [-C-C] - [-D-C] - [-C-C_1] - [-P-C] - [-Pr-C] - [-S-C] 
KF3 = P3[KF2] -[-Fix-C] 

 

Then, export the data and transpose in excel ( As you know, because of the calculated column, you can’t transpose in ‘Edit Query’ ):

e6.PNGe7.PNG

 

Then, import the data and calculate the ‘sum’ and sort each row:

 

e10.PNG

(My data’s sort is wrong, just for reference)

 

e11.PNG

 

Best regards,

Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors