joins
1 Topic
Left outer join by combing two tables
Hi All, I am very new to power bi. I am trying to create a new output table using the calculated columns from the other table. I tried using the natural join function but I was un-able to create a new table sucessfully. I know that this can be achieved easily in the sql but I am not quite familiar with the DAX. Any suggestions will be very helpful. Thanks Table 1 Month Year Cat 202401 c1 202402 c1 202403 c1 202404 c1 202405 c1 202401 c2 202402 c2 202403 c2 Table 2: Month Year Cat Code Date 202401 c1 1 23-Jan-24 202402 c1 1 2-Feb-24 202403 c2 2 31-Mar-24 202405 c1 1 24-May-24 202405 c1 2 25-May-24 Output: Month Year Cat Code Date 202401 c1 1 23-Jan-24 202402 c1 1 2-Feb-24 202403 c1 202404 c1 202405 c1 1 24-May-24 202405 c1 2 25-May-24 202401 c2 202402 c2 202403 c2 2 31-Mar-24 202404 c2 202405 c2Solved1.4KViews0likes7Comments