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 , 23 just gives me the same result as previously, sums all columns with a value.

 

22, errors, might be due to the fact that I have several columns. the error is "DataFormat.Error: We couldn't convert to Number."

 

 

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

    you have a sorting problem and  column names
    I can’t help with without the file