Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Kedar_Pande
Super User

yuvan29 

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