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 fo...
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.
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