Forum Discussion
Solved
Common join column error question when joining between Power BI many-to-many relationship tables.
We are going to attempt a JOIN between the two tables below in Power BI. The goal of calculation is to be able to check by time zone in the view table as the time zone appropriate for each type thro...
Sounds like you are attempting to do the join in DAX. For that you need to use CROSSJOIN and then filter down to the matching types.
Would be better to do this in Power Query, it supports full outer joins etc.
Sounds like you are attempting to do the join in DAX. For that you need to use CROSSJOIN and then filter down to the matching types.
Would be better to do this in Power Query, it supports full outer joins etc.