Left Outer join with DAX

Question

I have 3 table here&nbsp;This is what I get in PBI when I created relationship with 1-many ( machine status to facttable) and (alarmcode to facttable)but I miss the result of loss duration in some parts (ex. 9.08AM)&nbsp;&nbsp;This is when I drag Machinestatus out, you can see the result of 9.08 AM&nbsp;So I think I need to do some leftouterjoin but I cannot do this with power queryIs there any solution for this?Thank you

some_bih · Answer

Hi&nbsp;Earkkaperk&nbsp;check link for creation left outer join in PQ

earkkaperk · Answer

Hi, I cant do the power query as the one of the dataset is from direct query

some_bih · Answer

Hi&nbsp;Earkkaperk&nbsp;there are some limitations like on link. Still, if you can not see added columns check other people experience at community forum link (post 20)

earkkaperk · Answer

Hi,I cannot do the power query.. as you said it is from direct query.and for the volume I cannot see, it is because when I do the relationship between Facttable and Machinestatus/ FactTable &amp; Alarmcode, the data is missing in my table because there is no data from MachineStatus and Alarmcode during those days.&nbsp;My point is it need to be left outer join from FactTable so that I can see all of the data from FactTable whether there is data from Machine Status or AlarmCode or not.

some_bih · Answer

Hi&nbsp;Earkkaperk&nbsp;without your model and relationships it is hard to spot issue.
Still, according to your picture and description from initial post, it seems that you have columns which are not in Fact Table.
Please provide model with relationships and other details like these are inputs and expected output.

&nbsp;

Forum Discussion

Left Outer join with DAX

5 Replies

Related content

Left Outer Join through Relation ship joining

Left outer join

Natural Left Outer Join in DAX?

How to create left outer join the power bi

Power BI Pl 300 exam questions - Inner Join, Left outer Join and Right Join