Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |