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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
strince
New Member

How to Perform Full-Outer Join on Two Separate, Filtered/Sliced Tables in DAX?

I have an original table named `Error`, and two additional tables (`ErrorBefore` and `ErrorAfter`) derived from the original (e.g. `ErrorAfter = ALLSELECTED('Error')`). I want to compare values from a 'before' version with an 'after' version, with the different version picked by slicer with 'Single select' on. That's working okay. Now I want to perform a full-outer join on the two results, joining on the `Message` column. The image below shows the result I have so far, with a fabricated table at the bottom of what I'm trying to achieve. I've tried using `NATURALLEFTOUTERJOIN` and `GENERATE` but they either don't give the result that I seek. Does anyone know how to perform the join?

 

PBIX is here.

 

2019-07-10_14-50-48.png

1 ACCEPTED SOLUTION
strince
New Member

Someone was able to provide the answer on Stack Overflow.

View solution in original post

1 REPLY 1
strince
New Member

Someone was able to provide the answer on Stack Overflow.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors