I am trying to add a column to a table which shows the daily variance from the previous day.
My table looks something like this:
Measure
Date1 5
Date2 2
Date3 9
Date4 7
I would like to add another column showing the variance from the previous day like this:
Measure Variance
Date1 5 5
Date2 2 -3
Date3 9 7
Date4 7 -2
I tried creating a new measure using the following formula but I didn’t get the result I expected: =Var([Total Value of Trades])
Any help appreciated.
My table looks something like this:
Measure
Date1 5
Date2 2
Date3 9
Date4 7
I would like to add another column showing the variance from the previous day like this:
Measure Variance
Date1 5 5
Date2 2 -3
Date3 9 7
Date4 7 -2
I tried creating a new measure using the following formula but I didn’t get the result I expected: =Var([Total Value of Trades])
Any help appreciated.