Forum Discussion
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...
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!
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