Forum Discussion
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 (or in any date that i choose from the date slicer)
i whant to create a column that will show me the value for the average column in the last day, for example:
if i looking on data from 3.5.18, i whant that the column will show me the average value for the 2.5.18.
columns:
userlogin - numbers of servcalls - number of workdays - average execution
now, i take the field "average execution" and put him on a visual "card"
i whant to create another card that will show me the "preveus day" value
thanks
1 Reply
- FloriankxSolution 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.