Previous Day Value comparing

[davidi4524]

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 

[Floriankx]

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.