topic Creating a line graph with current active tickets in DAX Commands and Tips

Creating a line graph with current active tickets

Anonymous — Fri, 21 Apr 2023 13:25:03 GMT

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

Re: Creating a line graph with current active tickets

johnt75 — Fri, 21 Apr 2023 15:28:30 GMT

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

Re: Creating a line graph with current active tickets

Anonymous — Fri, 21 Apr 2023 17:13:03 GMT

I can jump through hoops, it works perfectly

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