Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My average matters per day is not stopping on the current day.
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
Thanks @v-danhe-msft ,
Here is the data:
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |