Forum Discussion
samoberoi
Helper III
Helper IIINetwork days from a certain date
Hi All, I have a query on some work which has previously been done on Excel and now it has to be done on Power BI. It is just to calculate the number of network days from a joining or leaving dat...
see attached
samoberoiHelper III
Helper III
EXPECTED RESULTS
| April capacity (Days) | May capacity (Days) | June capacity (Days) | July capacity (Days) | ||
| AA-BB-123 | 16 | 23 | 20 | 23 | |
| AA-BC-125 | 22 | 23 | 20 | 23 | |
| AA-BB-124 | 5 | 0 | 0 | 0 | |
| AC-BC-123 | 0 | 0 | 14 | 23 | |
| CA-BB-125 | 22 | 5 | 0 | 0 | |
| AD-BD-123 | 22 | 23 | 20 | 23 | |
| AA-BB-111 | 6 | 0 | 0 | 0 |
SECOND ISSUE
- In my COALESCE formulas you can replace the hardcoded dates with your min and max fact dates.
Related to the second issue, i tried to use Min & Max for the dates from the fact table Table A in this example, but it still doesn't work.
Hope i could be explain it better and could be provide better sample data.
Thanks again.
