Forum Discussion
Solved
DAX Query Multiple Union
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")))
Seems like you need something like NATURALINNERJOIN
1 Reply
Seems like you need something like NATURALINNERJOIN