How to add multiple "calculated columns" in Power Query?

[aliraza]

For Example, I want to add 2 columns using power Query by making a measure of subtraction on 4 columns from my CCL table. Let I have these 4 columns:

MAT Value 19        MAT Value 18           MTH 19        MTH 18

I want to calculate:

MAT Diff= [MAT Value 19] - [MAT Value 18]

MTH Diff= [MTH 19] - [MTH 18]

i.e, I want to use the following query for multiple subtractions.

= Table.AddColumn(#"Changed Type1", "Subtraction", each [MAT_VALUE_19] - [MAT_VALUE_18], type number)

[Nolock]

Hi @aliraza,

this blog post could help you to automate your solution: https://community.powerbi.com/t5/Community-Blog/Solving-Real-Life-Problems-with-Recursive-Functions-....

But I think it'll be simpler to click some queries in the UI of the PowerQuery Editor, if you have only few columns in one table.