Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
104 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |