Daily Average up to today

[clivebredenkamp]

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.

[v-danhe-msft]

Hi @clivebredenkamp ,

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

[clivebredenkamp]

Thanks @v-danhe-msft ,

Here is the data:

Billing DataDates Table

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