Date Diff on Different tables with multiple date values

Your Account ID seems to be a primary key.  Create an Account dimension that lists the Account IDs and then control both of your fact tables from that dimension.  Then the measures write themselves.

Hi RoyalJ 

Thanks to lbendlin  for your prompt reply. Here are my additions:

Measure does not work as a slicer, but it can be put into Filters on this visual, I'm just not sure what kind of filtering you need to do, we are better able to help you if you can provide more information.

Here is the testing I've done so far.

Create another Measure to filter out IDs with datediff > 5 days

>5 = CALCULATE(MAX([Trade ID]), FILTER(Trade, [Diff] > 5))

Output:

Or put the Diff into a visual level filter for filtering.

If I've misunderstood you, please provide the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.