Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
I can jump through hoops, it works perfectly
Thanks very much, I can now go to bed and have a peacefull night
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
)
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |