Radoslaw Poprawski
Active Member
- Joined
- Jun 19, 2021
- Messages
- 398
- Office Version
- 365
- Platform
- Windows
Hi all:
I have the below Code and I wonder how can I transform it into a function where
[#"Reporting code"] - is the internal column name from the Table T_Multiplier
OT[#"Reporting code"] is the outside column of the same name.
I have the below Code and I wonder how can I transform it into a function where
Power Query:
= List.Sum( Table.SelectRows(Excel.CurrentWorkbook()
{[Name = "T_Multiplier"]}[Content],
(OT) => [#"Reporting code"] = OT[#"Reporting code"] )[#"Reporting Multiplier Value"]) )
OT[#"Reporting code"] is the outside column of the same name.