Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Issue with left outer join

i have a table with start date , end date , name , allocation and only the month for which allocation is given.Capacity is 1 for all (created new column with 1 a value). I created one table us...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks selimovd and Amit for reply.

 

Yes I am using DAX for left outer join.

 

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    4 years ago

    Hi Anonymous

     

    Maybe the many-to-many relationship is causing the issue, you can merge the two tables in Query Editor.

     

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      The table is created using dax. I cannot view that table in query editor. As per my understanding the join has to be done using dax only

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      We cannot do this in power query because the table "Table" is created using dax. I cannot merge in power query. While using dax I first related the table using emp id , but it wasnt relating and same is the case with date column. How can i join the table using left outer join. Please find below  lin for pbix file.

      https://www.dropbox.com/t/M9HO0EgGz5heimhO