What I wanted to do in this example is to show you how you can manage multiple dates in your Power BI tables. This is a very common issue I see that new Power BI users are experiencing with their...
Updated 7 years ago
Version 3.0
Blog Post
In the examples the data set had a start date and an end date. How do you include all rows that do not have an end date?
| Ticket | Open | Closed |
| 1 | 2020-01-01 | 2020-01-04 |
| 2 | 2020-01-3 | |
| 3 | 2020-01-5 | 2020-01-06 |
The table should look like this:
| Date | Open Tickets | |
| 2020-01-01 | 1 | Ticket 1 opened |
| 2020-01-02 | 1 | Ticket 1 still open |
| 2020-01-03 | 2 | Ticket 2 opened |
| 2020-01-04 | 1 | Ticket 1 closed |
| 2020-01-05 | 2 | Ticket 3 opened |
| 2020-01-06 | 1 | Ticket 3 closed |