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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Earkkaperk
Frequent Visitor

Left Outer join with DAX

I have 3 table here

Earkkaperk_0-1725247027425.png

 

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)

Earkkaperk_1-1725247164098.png

 

 

This is when I drag Machinestatus out, you can see the result of 9.08 AM

Earkkaperk_2-1725247204941.png

 

So I think I need to do some leftouterjoin but I cannot do this with power query

Is there any solution for this?

Thank you

5 REPLIES 5
some_bih
Super User
Super User

Hi @Earkkaperk check link for creation left outer join in PQ





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






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

Hi @Earkkaperk 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)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






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 & Alarmcode, the data is missing in my table because there is no data from MachineStatus and Alarmcode during those days.

 

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.

Hi @Earkkaperk 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.

some_bih_0-1725517793623.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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