cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShaunW New Member
New Member

Using date and ID column to compare rows from two tables

Hi All,

 

I'm looking to create a measure that can tell me how many contacts that I did not meet with in the 4-8 weeks after I requested a meeting. I'm strugging and can't seem to get the right combination of FILTER functions (of which, I'm a novice).

 

I have 3 tables: 1) Meeting Requests, 2) Meetings and 3) Contacts:

 

Image 1.jpg

 

The desired outcome in the above scenario is 1 (red). I reached out on 2/1/2018 and didn't meet in the next 4-8weeks.

 

Ultimately I'd like to be able to slice this measure in visuals by year. Potentially other slices as well.

 

Any ideas?

 

Appreciate the help.

 

Thank you.

 

Shaun

 

2 REPLIES 2
cpmohanraj Frequent Visitor
Frequent Visitor

Re: Using date and ID column to compare rows from two tables

My suggested approach,

 

 - Add a date column in the Meeting Requests that will represent 4 - 8 weeks boundary from the request date

 - The above step creates a date range for every meeting request and all that we need to do is to check if there was any meeting with the respective person held between this date range

 

You may know a better way of doing this date range join. I came across a post that explains how to use DAX table function to create a date range join - Join Data on Date Range

 

Hope this helps.

Community Support Team
Community Support Team

Re: Using date and ID column to compare rows from two tables

@ShaunW,

 

Just like CONTAINS, you may try using COUNTROWSFILTER and DATEDIFF in a measure.

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 236 members 2,425 guests
Please welcome our newest community members: