Forum Discussion

Do5779's avatar
Do5779
Icon for Helper II rankHelper II
3 years ago

Norlamize Matrix table to n:1 connection

Hello Experts,

I feel really silly, because I got this input data and want to normalize it in order to build a graph with the Month as x- axis and the Workload as y-axis, but I cant transponend the data and build a sum, because I also need the individual values (to select the worker and the graph is changed) and to get a connection to the Calendar... I have searched a lot but didn't find the right answer yet.

How can I normalize this table in Power query?



Only for imaging the bar chart:




Tanks a lot for your help.

No RepliesBe the first to reply