cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
davidi4524 Member
Member

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 1
Floriankx Established Member
Established Member

Re: Previous Day Value comparing

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.