Forum Discussion
Solved
Filter data between start and end dates
Hi, I am relatively new to Power BI but have used other similar software (Tableau) on and off for about 2 years now. I am using Power BI in the construction sector and am trying to use the contra...
amitchandak thanks for your help. I had previous seen the HR current employee example but struggled to make it work. In the end I used a variation of it (combined with another community response):
Ongoing check =
VAR SelectedDate =
SELECTEDVALUE('Week Numbers'[Value])
RETURN
CALCULATE(COUNTROWS('High Level Sequence'),'High Level Sequence'[Finish] >= SelectedDate,'High Level Sequence'[Start] <= SelectedDate)