Subtract column from number value

[jamieham]

I want to subtract a column from number value and dont know how to do it in DAX.

How would I subtract the column 'Value" from 70?

Value

23

14

68

12

[Greg_Deckler]

@jamieham - The measure form is 

Measure = 70 - MAX('Table'[Value])

Assuming your visualization has the [Value] column displayed in something like a Table visualization.

[amitchandak]

@jamieham ,

Create a new column

new column = 70 -[Value]

This should work both in Dax and M

[FarhanAhmed]

Go to Modelling Tab on Top of PBI Desktop, there is an option to create New Column in Calculations

Create a new column in table

NewColumn = 70 - Table[Value]

[pranit828 · Accepted solution]

Hi @jamieham 

Create a measure or a new column

M1 = 70 - Table[Value]