'PowerBI - Showing all values from one dataset after join
I apprecicate that this must be a fairly simple issue to overcome however I have tried all join types with no success.
My data is structured in two excel files, one for 2022 and one for 2021. Headings are roughly the same on both :
ID Name 2021 Quantity 2021 Assessment
1234 Name1 32 High
5678 Name2 9 Low
9112 Name3 1 Medium
and the same for 2022 :
ID Name 2022 Quantity 2022 Assessment
3456 Name1 14 Medium
7891 Name3 23 Medium
1001 Name4 1 Low
I can join both sets on the NAME field, however the 2021 file will contain some Names that are not on the 2022 file, and vice versa. I am interested in the 2022 file as my primary source, and would like to show, in a table, all records and if there is a 2021 quantity (if not, show a blank). Output should look something like the below
ID Name 2022 Quantity 2022 Assessment 2021 Quantity
1234 Name1 32 High 14
5678 Name2 9 Low
I have experimented with one-to-many and many-to-many joins and various filters however every output seems to filter off the records where there is no join?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
