Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Creating a line graph with current active tickets

Hi there

I love power bi but for this time a struggling how to solve the next problem. I have a table where I have starting date and an end date where problem is fixed. 

I want to create a line graph based on dates where I can see how many ticket are active on any current date as they fall between start and end date or are still active as there is no end. Can anybody help me out

 

For the moment I did not connect the table to a date table

 

Best regards

Eric 

2 REPLIES 2
Anonymous
Not applicable

I can jump through hoops, it works perfectly

Thanks very much, I can now go to bed and have a peacefull night

 
johnt75
Super User
Super User

You don't need a relationship with the date table, just use

Active cases =
VAR RefDate =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        'Table'[Start date] <= RefDate
            && (
                ISBLANK ( 'Table'[End date] )
                    || 'Table'[End date] > RefDate
            )
    )

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.