Forum Discussion
Delta Values from Previous Day Using Multiple Columns
- Anonymous9 years ago
So... I can't see why there would be a ciruclar dependency error, but my expression isn't QUITE correct either, please update, and maybe do a "plz work, plz work, plz work" dance :)
VOLUME_DELTA =
VAR Yesterday = MyTable[StartTime] - 1
VAR MyMaterial = MyTable[Material Number]
VAR MyElement = MyTable[Element]
RETURN
MyTable[Volume] -CALCULATE(VALUES(MyTable[Volume]),
FILTER(ALL(MyTable),
MyTable[StartTime] = Yesterday &&MyTable[Material Number] = MyMaterial &&
MyTable[Element] = MyElement
))
Try this measure:
Delta Measure = SUM(MyTable[Volume]) - CALCULATE(SUM(MyTable[Volume]),DATEADD(MyTable[StartTime],-1,DAY))
Then just create a Table or Matriz Visualization and done!