Forum Discussion
how to join tables
I finally got the solution ...
Make a new table ...
Table = Filter( Crossjoin ( table A, TableB ), cond1&&cond2&&cond3....)
And it works ...
Microsoft Employee
My approach may not be the best, but here goes:
I would start with a merge as new query operation within the query editor.
You can perform all the select aspects after the merge (i.e. removing columns).
You join sheet2 and sheet3 on Unit ID, choosing the appropriate type of join.
Once you have this new merged query, merge it (as new query) with the sheet1 table using DateStart and Date as the fields, and choose the appropriate join type to return all rows from the fact table with only the matching rows from the date table.
Repeat this process, using the original merged query, but use the DateEnd field.
Append the two final merged tables (date start and date end).
Remove the columns you don't need.
sorry ... i am not too sure what you are telling me to do there ...
My knowldge of power bi is too low...
Could you be more precise may be ?
Rgds
- dkay84_PowerBI
This is all done in the query editor. Are you familiar with this part of Power BI (Get and Transform, formerly Power Query, in Excel)?
I finally got the solution ...
Make a new table ...
Table = Filter( Crossjoin ( table A, TableB ), cond1&&cond2&&cond3....)
And it works ...