Forum Discussion

jadewind's avatar
jadewind
Advocate I
9 years ago
Solved

Matching dates

I have two tables, one showing people's IDs, Locations and Start Date and End Date of people's locations , the other one showing incidents with Incident Date and people's IDs.    I want to find out...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi  jadewind，

    I haven't created ant relationship between the two tables. You can check the attached PBIX file to get more details about how to create the calculated column.

    Thanks,
    Lydia Zhang

jadewind's avatar
jadewind
Advocate I
9 years ago

Or I think the bit after <= has to be a measure not a column?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi  jadewind，

I haven't created ant relationship between the two tables. You can check the attached PBIX file to get more details about how to create the calculated column.

Thanks,
Lydia Zhang