Solved: Remove VAT

Anonymous · ‎10-12-2022

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 · ‎10-12-2022

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

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Stachu · ‎10-12-2022

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

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous · ‎10-12-2022

Thank you Stachu,

Nice and easy solution. Thank you very much.

Best,
JT

Remove VAT