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
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

pls try this

List.Sum( List.Transform(
List.Range( Record.FieldValues(_),
MGoM[Index]{0},MGoM[Index]{ List.Count(MGoM[Index])-1}),Number.From))

 

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

Ahmedx Thank you so much for all your efforts but unfortunately this doesn't work either, not sure why 

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

    you can only give two lines to see what the problem is