Remove VAT

[Anonymous]

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 · Accepted solution]

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]

Thank you Stachu, 

Nice and easy solution. Thank you very much. 

Best, 
JT