Check if reservation daterange is within selected month

[tuulia]

Hi!

I have a reservation report with (sample)data like this:

I have a datefilter in report from where enduser can pick a startdate-range they want. If user selects 1.2.2023 - 28.2.2023 report shows only reservations where startdate is in February (reservations 3 and 6). Thats fine.

But I also need my report to show reservations 1, 2 and 4 because those houses are reserved whole February/some days of February. How can I achieve this?

[amitchandak · Accepted solution]

@tuulia , refer these approaches should help

between date Measure
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...