Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
New Measure
Average Calls Last 3 Days =
VAR SelectedTime = SELECTEDVALUE('YourTable'[Time])
VAR SelectedDate = SELECTEDVALUE('YourTable'[Date])
RETURN
AVERAGEX(
DATESINPERIOD(
'YourTable'[Date],
SelectedDate,
-3,
DAY
),
CALCULATE(
SUM('YourTable'[NumberOfCalls]),
'YourTable'[Time] = SelectedTime
)
)
Add a Line Chart
Put your Time on the X-axis.
Use the measure Average Calls Last 3 Days for the Y-axis.
๐ If this helped, a Kudos ๐ or Solution mark would be great! ๐
Cheers,
Kedar
Connect on LinkedIn