Need to find interval from two date columns which is from different tables

[saikarthick]

Hi Everyone,

I need to find interval from two date columns which is from different tables and not in direct realationship

Interval days = 'customer_policies'[Approval_date] - 'policy_sales'[sale_date]

Facing some issue in sharing screenshot, otherwise i would have shared it.

so, Relation between tables are below:

customer_policies[customer_id] ---many to one --customer[customer_id]

customer[customer_id] --- one to many ---policy_sales[customer_id]

Kindly some one help on this with explanation if possiblle.

Thanks in advance.

[v-shex-msft]

Hi @saikarthick,

I'd like to suggest you to add a calculate column at 'many side' to reference date column from 'one side', then you can simply use datediff function to calculate interval.

Regards,

Xiaoxin Sheng

[saikarthick]

Thanks bro. I am very new to power bi.

Can u please explain me with an example. If possible on same scenario.

[v-shex-msft]

HI @saikarthick,

Can you please share a sample pbix file? I will add sample formula on it.

Regards,

Xiaoxin Sheng