Dax for calculating average Due% by month

liberty20 — Wed, 07 Sep 2022 04:47:37 GMT

Hi All,

I am trying to figure out how to calculate "Average of Due% by No.of days in a month"

For Example:

Day	Overdue %
0	10%
1	10%
2	10%
3	10%
4	8%
5	8%
6	8%
7	8%
8	8%
9	8%
10	8%
11	8%
12	8%
13	8%
14	8%
15	0%
16	0%
17	0%
18	0%
19	0%
20	0%
21	0%
22	0%
23	0%
24	0%
25	0%
26	0%
27	0%
28	0%
29	0%
30	0%
Avg	4%

Overdue % / No. of Days in a month
120/30 = 4%

Trying to achieve the same in DAX!

Note : No. of days will be differ from month to month eg. feb=28, Jan=31

Thanks in Advance!

Re: Dax for calculating average Due% by month

Anonymous — Thu, 08 Sep 2022 01:48:18 GMT

Hi liberty20 ,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

topic Dax for calculating average Due% by month in Developer

Dax for calculating average Due% by month

Re: Dax for calculating average Due% by month