I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your datamodel.
expected result measure: =
VAR _condition =
Data[Startdate] <= MAX ( 'Calendar'[Date] )
&& Data[Enddate] >= MIN ( 'Calendar'[Date] )
HASONEVALUE ( Data[ID] ) && HASONEVALUE ( 'Calendar'[Year-Month sort] ),
IF ( _condition = 1, "Present", "Absent" )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Go to My LinkedIn Page