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.
As usual when you transition from Excel to Power BI, the first thing you need to do is unpivot your data to bring it into a usable format. After that you can decide if you even want to do the calculations in Power Query, or if it is simpler and faster to do them in Power BI.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUjDUMzBQUNIBMyyhDEMLKMPYDMowgUlZmEMZlhARIz0jE5h2g4FmxMYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"2024/9" = _t, #"2024/6" = _t, #"2024/3" = _t, #"2023/12" = _t, #"2023/9" = _t, #"2023/6" = _t, #"2023/3" = _t, #"2022/12" = _t, #"2022/9" = _t, #"2022/6" = _t, #"2022/3" = _t, #"2021/12" = _t, #"2021/9" = _t, #"2021/6" = _t, #"2021/3" = _t, #"2020/12" = _t, #"2020/9" = _t, #"2020/6" = _t, #"2020/3" = _t, #"2019/12" = _t, #"2019/9" = _t, #"2019/6" = _t, #"2019/3" = _t]),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Month", "Value"),
#"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Columns",{{"Value", type number}})
in
#"Changed Type"