Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
saikarthick
Frequent 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
v-shex-msft
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

Thanks bro. I am very new to power bi.

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

HI @saikarthick,

 

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

 

Regards,

Xiaoxin Sheng

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.