Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @jamieham
Create a measure or a new column
M1 = 70 - Table[Value]
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@jamieham - The measure form is
Measure = 70 - MAX('Table'[Value])
Assuming your visualization has the [Value] column displayed in something like a Table visualization.
Create a new column
new column = 70 -[Value]
This should work both in Dax and M
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]
Proud to be a Super User!
Hi @jamieham
Create a measure or a new column
M1 = 70 - Table[Value]
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
User | Count |
---|---|
96 | |
85 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |