Forum Discussion
Create relationship: 1 date from 1 table being between 2 dates in 2 columns in another table
I found this thread. Pretty helpful in walking you through the processs in how to expand a table based upon two different date fields. Only thing to add is to change your field names you're referencing in the formula!
Pretty easy.
Super UserI would suggest that you populate eff date into the claim table. You can get a column from one table to another based on required no of condition
New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
If I populated the 'Eligibility Data'[Eff Date] into the 'Claims Table'...how would I account for the 'Eligibility Data'[Term Date]. I don't believe bringing in the 'Eligibility Data'[Eff Date] into the 'Claim Data' Table would accomplish anything. I still need to account for the 'Eligibility Data'[Term date].
Also, as stated before, a Member ID can populate many times in both tables. Not sure how that would impact what your solution suggests.
A claim is only eligibile if the 'Claim Data'[From Date] is between the 'Eligibility Data'[Eff Date] and 'Eligibility Data'[Term Date] for that Member ID.