John Altamura on 14 Dec 2018 22:18:38
I would like to have the ability to return all rows from both tables in Power BI, when fields from both tables are present in the same visualisation, and there is nothing to join on in the relationship column. This would be equivalent to a SQL FULL OUTER JOIN.
I would also like the ability to return all rows from the "One" side of a One:Many relationship, when fields from both tables are included in the same visualisation. This would be the equivalent of a SQL LEFT JOIN where the table on the "One" side of the relationship is on the left. Currently the default join for a One:Many relationship in Power BI is effectively a LEFT JOIN with the table on the "Many" side of the relationship on the left.
- Comments (1)
RE: FULL OUTER JOIN and LEFT JOIN from One to Many
When I posted this, I had in mind using DAX to join! - I know this can be done already in M.