Forum Discussion
Remove VAT
Hi All, FACT TABLE[Amount] My 'Amount' column contains VAT. What is the proper way of removing VAT. or divide by 1.2 Many thanks, JT
You could modify it at source/in Power Query, so that the data loaded would be without VAT.
If VAT is always 1.2, and there are no different rates depending on product/time then you could use a measure:
Amount (no VAT) = SUM('FACT TABLE'[Amount]) / 1.2
You could modify it at source/in Power Query, so that the data loaded would be without VAT.
If VAT is always 1.2, and there are no different rates depending on product/time then you could use a measure:
Amount (no VAT) = SUM('FACT TABLE'[Amount]) / 1.2Thank you Stachu,
Nice and easy solution. Thank you very much.
Best,
JT