Forum Discussion
Solved
Check if record from table A falls within a date range in table B
I have a table that I'll call Event. Event date person_id I have another table called Biography. Biography start_date end_date person_id title Every Event row should be ...
Hi,
Try this calculated column in the Events Table
=CALCULATE(FIRSTNONBLANK(Biogaphy[title],1),FILTER(Biography,Biography[start_date]<=EARLIER(date)&&Biography[end_date]>=EARLIER(date)&&Biography[person_id]=EARLIER(person_id)))
If this formula does not work, then share the link from where i can download your PBI file.
That worked. Thank you! I guess the EARLIER function was what I needed.
Ashish_Mathur
Super User
Super UserYou are welcome.