Forum Discussion

obriaincian's avatar
obriaincian
Icon for Resolver I rankResolver I
2 years ago

Unpivoting and re-Pivoting creating duplicates

Hi All,   I have the below table in Power BI    Index  Manager First Name    Manager Last Name   HC Aug-23        HC Sep-23      HC Oct-23     HC Nov-23      HC Dec-23        HC Jan-24...
Need Help
obriaincian's avatar
obriaincian
Icon for Resolver I rankResolver I
2 years ago

Ahmedx thank you for the reply, however it looks like this is summing all columns that have a value in my table (my dataset is much bigger than in the sample provided). Any idea why it's summing all columns?

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

write this and show the result