Forum Discussion
Solved
Do math with matrix cells
Hello! I'm pretty new to PowerBI and still learning the ropes. But to not ramble too much, here's my question - I have a table that I'm trying to add a new value to by using other values within t...
You may modify the measure like pattern below:
Result = VAR Current_Month = MAX ( Table[Month] ) VAR Previous_MMs = CALCULATE ( MAX ( Table[MMs] ), FILTER ( Table, Table[Month] = Current_Month - 1 ) ) VAR Current_Entering_MMs = MAX ( Table[Entering MMs] ) VAR Current_Total_H = MAX ( Table[Total H] ) RETURN Previous_MMs + Current_Entering_MMs - Current_Total_HCommunity Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You may modify the measure like pattern below:
Result =
VAR Current_Month =
MAX ( Table[Month] )
VAR Previous_MMs =
CALCULATE (
MAX ( Table[MMs] ),
FILTER ( Table, Table[Month] = Current_Month - 1 )
)
VAR Current_Entering_MMs =
MAX ( Table[Entering MMs] )
VAR Current_Total_H =
MAX ( Table[Total H] )
RETURN
Previous_MMs + Current_Entering_MMs - Current_Total_H
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks! This got me 95% of the way there and it was easy to figure out the rest.