Calculate GST on column without creating a new column

[Nudo]

Hello

I've been asked to take off the GST on our source data coming from Salesforce. I'm pretty sure it must be possible but can't figure out exactly what to do. As I've already created the whole report with measures and calculated columns based on the current $$$ column from the source. I'm wondering if there's anyway in Advanced Editor I can divide the current value in this column by 1.1 to get a new value in the same column so I don't have to create a calculated column and go through and find every where I used this original column

Thanks

[Nudo · Accepted solution]

Stumbled across the answer for anyone who wants to do this in the future and isn't sure. In query editor click on the column you want to do any calculation on in this case divide. Go click on the transform tab and find the standard dropdown. This will allow you to do a calculation on the whole column without having to do some power query, nice.

[v-zhangti]

Hi, @Nudo 

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards