Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |