cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saikarthick Regular Visitor
Regular Visitor

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

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.

3 REPLIES 3
Highlighted
Community Support Team
Community Support Team

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

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
saikarthick Regular Visitor
Regular Visitor

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

Thanks bro. I am very new to power bi.

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

Community Support Team
Community Support Team

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

HI @saikarthick,

 

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

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |