Forum Discussion

Earkkaperk's avatar
Earkkaperk
Frequent Visitor
2 years ago

Left Outer join with DAX

I have 3 table here   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 ...
Need Help
Show and Tell
Tips and Tricks
  • Earkkaperk's avatar
    Earkkaperk
    Frequent Visitor
    2 years ago

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

    • some_bih's avatar
      some_bih
      Icon for Community Champion rankCommunity Champion
      2 years ago

      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)

      • Earkkaperk's avatar
        Earkkaperk
        Frequent Visitor
        2 years ago

        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.