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")

     

Mederic's avatar
Mederic
Post Patron
6 months ago

Sorry, I went too fast, I didn't get the right result or couldn't get it.
I'll put the file that works.

However, I would have liked to reduce the number of steps.

Best regards

ronrsnfld's avatar
ronrsnfld
Super User
6 months ago
  1. What is the purpose of reducing the number of steps?
       Any other problems with your output in your file?
  2. To obtain the results you can either do the unpivot/pivot process (as in your example) or you could
             demote headers/transpose/promote headers
  3. What do you mean by the "four most recent dates"?
        The dates you are showing in your results are merely the first four in your table which, because your table is sorted ascending, are merely the first four dates in your table.
  4. Why are you using List.Sum in your pivot code? It seems you only have a single intersection of date/attribut so what are you trying to Sum?