Power BI Guide: Open in Period
Have you ever tried to visualise the date periods (months, weeks, days) that an event was open in as opposed to the date period the event was created or closed within? It can be a tricky problem, but this Power BI Guide offers a solution! We use an example of absence data to show which absences were open in each month, even if the start and end dates overlap two or more months.
If you'd like to download the dataset or PBIX file used in this video, you can access them here: https://cutt.ly/Oy3NQss
For more information on using Date/Calendar Tables, have a look at the guide here: • Power BI Guide: Date Tables (Calendar Tables)
#PowerBI #PracticalBI #BusinessIntelligence