Calculate if selected date is between two dates

Anonymous — Fri, 10 Jun 2022 11:21:30 GMT

Hi everyone!

I am struggling with a difficult problem. I have a fact table with 2 dates: Task Start Date and Task End Date. I have another dimension table (calendar table) with 2 inactive relationships between these 2 dates and calendar date. In calendar table I have information about Year and month.

How to calculate it in dax? I have tried with something using selectedvalue(calendar[year]), selectedvalue(calendar[month]) and combine it with these 2 dates, but it is incorrect. 1 should be inserted if calendar Year and calendar Month match to Year and Month these 2 dates.

Re: Calculate if selected date is between two dates

tamerj1 — Fri, 10 Jun 2022 12:43:24 GMT

Hi Anonymous

please use

= VAR MaxDate = MAX ( 'Calendar'[Date] ) VAR MinDate = MIN ( 'Calendar'[Date] ) RETURN SUMX ( TableName, IF ( TableName[StartDate] <= MaxDate && TableName[EndDate] >= MinDate, 1 ) )

topic Re: Calculate if selected date is between two dates in DAX Commands and Tips

Calculate if selected date is between two dates

Re: Calculate if selected date is between two dates