Forum Discussion

Mederic's avatar
Mederic
Post Patron
6 months ago
Solved

Transpose the 4 most recent dates

Hello everyone, I hope you are all well. I am attaching my sample file containing a tabble and Power Query code that is not working properly. Could you please improve it with a more elegant soluti...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    6 months ago

    Your pivot function is incorrect, referencing the wrong columns from the preceding step:

     Table.Pivot(#"Colonnes dépivotées", 
        List.Distinct(#"Colonnes dépivotées"[Attribut]), 
        "Attribut", 
        "Valeur")

     

ronrsnfld's avatar
ronrsnfld
Super User
6 months ago

Your pivot function is incorrect, referencing the wrong columns from the preceding step:

 Table.Pivot(#"Colonnes dépivotées", 
        List.Distinct(#"Colonnes dépivotées"[Attribut]), 
        "Attribut", 
        "Valeur")