March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 ?
I am unable to attach the pbix file. I dont see option to attach.
Thanks selimovd and Amit for reply.
Yes I am using DAX for left outer join.
Hi @Sarvina
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
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
Hey @Sarvina ,
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.
@Sarvina , 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
85 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |