Forum Discussion
Pivot and MOM
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.
nadian You will need a Calendar Table for these to work!
If you you don't have one visit Matt's link
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
If you do have a Calendar Table use these
Sean, thanks foor your replay.
I actually already did all you mentioned, now I'm trying to have the MOM column only for the last month.
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.
Thanks, looks great!