DAX Query Multiple Union

[emiec]

I'm trying to convert the following SQL query to DAX and need assistance.

SQL Query:

Select CJ.[Name], JS.Total_PN_hours, JS.Bonus_PN_hours
From CompletedJobs CJ
Left Join ScriptDetails SD ON CJ.[Name]=SD.ActivityName
Inner Join JobStatistics JS ON JS.JobId = CJ.ID
Where SD.ActivityName IS NULL

Here is what I have so far:

AdhocJobs = DISTINCT(FILTER(UNION(SELECTCOLUMNS(CompletedJobs,"Name",CompletedJobs[Name]),SELECTCOLUMNS(ScriptDetails,"ActivityName",ScriptDetails[ActivityName])),NOT ISBLANK("ActivityName")))

[Greg_Deckler · Accepted solution]

Seems like you need something like NATURALINNERJOIN