Forum Discussion
Calculation for every row
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
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.
2 Replies
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.
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