Forum Discussion

jamieham's avatar
jamieham
Icon for Helper II rankHelper II
6 years ago
Solved

Subtract column from number value

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
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi jamieham 

    Create a measure or a new column

     

    M1 = 70 - Table[Value]

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

jamieham - The measure form is 

 

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

 

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