Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 gra...
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

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
            )
    )