Hi,
First of all sorry if the title is not fit for the problem I have, but I just didn't know how to put it.
I have a table which looks something like this:
| Start_date | Submission_date | Approval_date | Reject_date |
| 01/09/2020 | 01/09/2020 | 02/09/2020 | |
| 01/09/2020 | | | 06/09/2020 |
| 02/09/2020 | 03/09/2020 | | 03/09/2020 |
| 03/09/2020 | 04/09/2020 | 05/09/2020 | |
| 03/09/2020 | 03/09/2020 | 05/09/2020 | |
| 03/09/2020 | 04/09/2020 | | 04/09/2020 |
| 04/09/2020 | 04/09/2020 | 04/09/2020 | |
Based on this information, I need to create several line graphs showing different cumulated counts. Basically, a count of the entries whose value is less than or equal to (<=) the value (date) being considered at the time.
For instance, I want to create a line graph that shows the cumulated count of entries which are completed and NOT rejected (Submission_date NOT blank and Reject_date blank). This graph's X axis should go from 1 to 31 (days of month), and show a different line for each month (thou in the example date only September information appears).
In table format, the cumulated count would look like:
| Date (Days) | Submitted_count | Approved_count | Rejected_count |
| 01/09/2020 | 1 | 0 | 0 |
| 02/09/2020 | 1 | 1 | 0 |
| 03/09/2020 | 3 | 1 | 1 |
| 04/09/2020 | 6 | 2 | 2 |
| 05/09/2020 | 6 | 4 | 2 |
| 06/09/2020 | 6 | 4 | 3 |
The problem I have is the first column here (Date (Days)) is an aggregation of column Start_date, and I think it is messing the results...
If I create a calendar table and create a relationship with whichever column in the main table the results will be the same as in the aggregation case, while if I don't create a relationship between the calendar table and the main table then Power BI doesn't know how to behave.
I hope I've been clear enough... I'm not that proficient with Power BI, and can't seem to get around this.
Any help will be welcome! Thanks!
