Forum Discussion
Help Joining 3 columns into one table
Good afternoon!
I need some help finding the correct join method to combine 3 columns into one table that will create the functionality I need.
the 3 columns are:
Column A, which contains all values.
Coulmn B, which contains a subset of values from column A.
Column C, which contains a different subset of values from column A.
I want to structure this so that a user can make selections from 2 different slicers (one which will filter Column B, the other will filter Column C), and the resulting values in Column A will be the values from column B and column C. Below is a quick visual:
| Column A | Column B (Filtered to value 1 by slicer) | Column C (Filtered to value 2 by slicer) |
| 1 | 1 | 2 |
| 2 | 1 | 2 |
Thanks in advance!
1 Reply
Hi Mstanford ,
you can use the default left outer joins to create a table like so:Column A Column B Column C 1 1 2 2 Make sure to use appropriate measures then to achieve the result like described here for example: Using OR conditions between slicers in DAX - SQLBI
