topic Re: Remove VAT in DAX Commands and Tips

Remove VAT

Anonymous — Wed, 12 Oct 2022 14:57:25 GMT

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

Stachu — Wed, 12 Oct 2022 15:14:10 GMT

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

Anonymous — Wed, 12 Oct 2022 15:19:43 GMT

Thank you Stachu,

Nice and easy solution. Thank you very much.

Best,
JT