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.
Active Items, Open Tickets, Outstanding Items, Open Claims - All names for basically the same calculation. In this video, we will discuss how to use DAX to enable the count of any "Active" item. In the sample data, there is only a stage created date and no stage end date, so we first create a stage expire date as a calculated column, then leverage the new column in our Active Ticket measure. Finally, we will display our Active Ticket measure in a Gantt chart visualization created using a Power BI matrix.
Extract the Dax from the Blog Post
watch?v=LVvaUSIYCCg