Need help with calculating a figure Pre VAT

[Bluen0ze_PAL]

Hi All 🙂

Just need help with Dax for making a new column that simply divides the value of an existing field by 1.2

Field name is HAmountPaid

Thanks 🙂

[ITManuel · Accepted solution]

Hi @Bluen0ze_PAL 

you can create a calculated column for example 

ColumnName = TableName[HAmountPaid]/1.2 or 

ColumnName = Divide(TableName[HAmountPaid],1.2)

Best regards

[Bluen0ze_PAL]

Worked perfectly thanks