Forum Discussion
Solved
Quick Measure Calculate difference from another row
Hi there, i am trying to use quick measure for the first time as i thought this functionality could help me out on this occasion. I have one dataset containing various economic indicator times serie...
Hi sebbyp,
Replace DIVIDE with your formula. For example.
Measure 5 = VAR US = CALCULATE ( SUM ( 'Table1'[Macro Trend Score] ), 'Table1'[Country] = "US" ) VAR EU = CALCULATE ( SUM ( Table1[Macro Trend Score] ), 'Table1'[Country] = "EU" ) RETURN US - EUBest Regards!
Dale
Hi sebbyp,
Replace DIVIDE with your formula. For example.
Measure 5 =
VAR US =
CALCULATE ( SUM ( 'Table1'[Macro Trend Score] ), 'Table1'[Country] = "US" )
VAR EU =
CALCULATE ( SUM ( Table1[Macro Trend Score] ), 'Table1'[Country] = "EU" )
RETURN
US - EUBest Regards!
Dale
This calculation you help me with previously was really helpful and done the trick. I would like to try something slightly differently this time around and take the difference for a countrys economic reading compared with the previous date. How can this be achieved. THe data is organised in the same table we spoke about previously in this conversation.