Forum Discussion
davidi4524
8 years agoHelper III
Previous Day Value comparing
hi. i have a table that show a number of service call that perform per technician i created a calculated column that show me the average number of the serice calls that each technician made today (...
Floriankx
8 years agoSolution Sage
How do you Calculate your average column?
I a Measure it would be
PreviousDay:=CALCULATE([Average],DATEADD(DateColumn,-1,days)
What also could work is using the same formula you used for average and wrap your day by PREVIOUSDAY.