Filtering between two date columns from different tables, but no relationship

[thhmez7]

Hello guys,

there are two tables with date column:

1) Account with Created on

2) Date [Date]

Due to the complex data model both fields cannot be connected with an active relationship.

Is it still possible, that both fields can filter each other?

Maybe with an inactive relationship and then create a column or measure for a new date-field?

Thank you.

[v-shex-msft · Accepted solution]

Hi @thhmez7,

You can refer to the following link to create a calculated table to expand table records and link to the original table field.

Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng

[amitchandak]

@thhmez7 , I would advise to create a date table, join with both table and filter using that

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.