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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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