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
In below table, How can we calculate No of Days and CDAB calculation in Power BI
For Eg as on 31-May-22
SUM_Balance_FY_MONTH = SUM of balance from 1 April 2022, i.e FY 2022-2023, 3687
No of days= NO of days from Finanicial year i.e from 1April 2022 to 31-May-22 ,61
CDAB = Sum_Balance_FY_Month/No of days
AS_ON_DATE | BALANCE | SUM_BALANCE _FY_MONTH | No of Days | CDAB |
1-Apr-22 | 326 | 326 | 1 | 326 |
2-Apr-22 | 240 | 566 | 2 | 283 |
3-Apr-22 | 434 | 1000 | 3 | 333 |
4-Apr-22 | 309 | 1309 | 4 | 327 |
5-Apr-22 | 200 | 1509 | 5 | 302 |
6-Apr-22 | 378 | 1887 | 6 | 315 |
30-Apr-22 | 600 | 2487 | 30 | 82.9 |
31-May-22 | 1200 | 3687 | 61 | 60.4 |
Solved! Go to Solution.
You could do the CDAB calculation in a single expression like the following:
Thanks!!It worked
You could do the CDAB calculation in a single expression like the following:
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 |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |