topic Re: Number of days w/i qtrs for a period of time in DAX Commands and Tips

Number of days w/i qtrs for a period of time

REL — Tue, 11 Mar 2025 23:27:25 GMT

I have a table of events with a start date and end date for each event. The start end and dates don't necessarily coincide with the start or end of months,quarters or years. I need to create a report with the event and the number of days, by year/qtr for the period of the event. I can use DateDiff to get the totals number of days or quarters between the start and end dates, but havent seen how to get the number of days, by qtr for the start to end date of the event.

Bob

Re: Number of days w/i qtrs for a period of time

lbendlin — Wed, 12 Mar 2025 01:23:10 GMT

You use INTERSECT() for that.

If you like more help please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Number of days w/i qtrs for a period of time

johnt75 — Wed, 12 Mar 2025 13:48:41 GMT

You can get the number of days in a period by creating a new measure

Event days = VAR StartDate = SELECTEDVALUE ( 'Events'[Start Date] ) VAR EndDate = SELECTEDVALUE ( 'Events'[End Date] ) VAR Result = CALCULATE ( COUNTROWS ( 'Date' ), KEEPFILTERS ( DATESBETWEEN ( 'Date'[Date], StartDate, EndDate ) ) ) RETURN Result

Put that in a matrix with your events and any column from the date table.

Re: Number of days w/i qtrs for a period of time

REL — Thu, 13 Mar 2025 18:43:52 GMT

That did it. Thanks