cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Daily Average up to today

My average matters per day is not stopping on the current day.

Avg Per Day = DIVIDE([Matters],SUM(Dates[IsWorkday]))

where IsWorkday = IF(ISBLANK(Dates[Holiday]),IF(Dates[DayOfWeekNumber]>1&&Dates[DayOfWeekNumber]<7,1,0),0)

and Matters = COUNT(BillingData[Item])

So today is the 27th of the month. So there are There are 18 of 20 work days completed for the month. How do I factor that in to my avarage and not affect previous months.

Any help appreciated.
2 REPLIES 2
Microsoft Employee

Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

Thanks @v-danhe-msft ,

Here is the data:

Current Result

Where

`Avg Per Day = DIVIDE([Matters],SUM(Dates[IsWorkday]))`

and

`Matters = COUNT(BillingData[Item])`

I expect the result to show an average per day for March of 1, becuase only one day has passed in March. Right now it is showing the result of 1/20 = 0.05 becasue there are 20 work days in March. It should show 1/1 = 1.

Today is 1 March.

Thanks

Clive