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
2 Replies
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