Calculation for every row

[Anonymous]

Hi all,

I had a question regarding making a calculation that has to be performed on every record in a column.

My data looks like this

X

7

29

7

82

118

Now what I want is for every row to be substracted by 5. With outcome like:

X

2

24

2

77

113

Is it best to do this through a calculated column ?

Thanks in advance,

L.Meijdam

[MarcelBeug · Accepted solution]

It depends.

If you want to keep the original values, you can either add a custom column in Power Query or a calculated column in DAX.

If you want to transform the values, you can use Power Query: Edit Queries - Transform - Standard - Subtract - 5.

[Anonymous]

Hi @MarcelBeug,

Since I prefered a DAX solution here I created a calculated column to achieve it. Thanks for sharing your insights with me.

Regards,

L.Meijdam