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 using below dax expression to grt extra rows for months between start date and end date.
table code:SUMMARIZE(filter(CROSSJOIN(Sheet1,'Date'),'Date'[Date]>=(Sheet1[startdate]) && 'Date'[Date]<=(Sheet1[end date])), [Month Year],[Month Year Sort],Sheet1[name],sheet1[empid])
Now i want to join these tables. Emp id is the matching column in both table but I am unable to do left outer join between table and allocation table. i am getting error "No common column joins detected".
Can anyone help me ?
10 Replies
Anonymous , you are trying dax left outer join ?
You should be able join sheet1 and new table, Just make sure ID column name is same
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Can you share a sample pbix after removing sensitive data.
Hey Anonymous ,
how do you want to join them?
As you're in DAX can you post the code you used for the join?
I personally would do the transformation in Power Query as it's part of the ETL process.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicHi 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!
