Forum Discussion

Regular Visitor

3 years ago

Solved

Question

Suppose you created a start date and end date filter on PBI page (not in filter pane). Now you want to compute average headcount between user selected start date and end date. How will you achieve th...

Data Protection

amitchandak
3 years ago
Abdult , Refer to the reply from AbbasG first. If that not help refer

You have an active headcount measure and take Avg like

Averagex(Values(Date[Date]) , [Head Count])

Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA

Memorable Member

3 years ago

Abdult as per my understanding, if you create a page filter. All the visuals on that page will reflect the filtered values.

As in your case it will show the avg. headcounts during that range.