Forum Discussion
Listwise multiplication in power query query
https://1drv.ms/x/c/7b02b2fed748fc63/ETzmzZMX2lJJl7G89fFRfyoBmaLUsZ_cX1TCog6kPPWZ4A Hi All values in certain columns in the table I obtained from the power query query I want to multiply a li...
you already have the data in the right format. All you need to do is NOT to do the last step.
Don't do the "PivotedColumns" step, and all will be good. You can then join your table with the inflation table
based on the Period.
hi
I couldn't understand how this had anything to do with what I wanted.
I don't use "power bi".
Can this operation be done in "power query"? If so, how.
The sample excel file is there.
Thank you.
you already have the data in the right format. All you need to do is NOT to do the last step.
Don't do the "PivotedColumns" step, and all will be good. You can then join your table with the inflation table
based on the Period.