Forum Discussion

jamieham's avatar
jamieham
Helper 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]

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi jamieham 

    Create a measure or a new column

     

    M1 = 70 - Table[Value]

     

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    6 years ago

    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]

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community 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.