Forum Discussion

nadian's avatar
nadian
Frequent Visitor
10 years ago
Solved

Pivot and MOM

Hi,   I'm having the following table:   Date        Ammount        Type January   100                  AAA January   300                  BBB February  400                  BBB February  500 ...
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    nadian

     

    For a transformation as below.

     

    You could follow the power query sample in attachement, the code seems over the max length and gets truncated, so I'm attaching it in a zip file.

     

    If you have any question, feel free to let me know.