joins

2 Topics

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 c2
Solved
Skumar100
2 years ago Place DAX Commands and Tips
1.4KViews
0likes
7Comments
Paginated Reports - PowerBi Data Source - Joins
Hi, I have had a look around about joining different datasets(tables) from the same PowerBi Data source and find it confusing if this is possible or not. This is how I am building reports in PowerBi Report Builder that use the same PowerBi Data source with different data sets(tables) I am using the same parameter filters on multiple tablix(pivot tables) that have different datasets(tables) from the same PowerBi Data source to make sure they are rendering the same filtered data on one report. I've also used sub reports to do a similar thing using parameters to filter each sub report again from the same PowerBi data source. Could someone advise if joins created in PowerBi Desktop are used in PowerBi Report builder when connecting to a Power Bi Data Service ? Many thanks Chris
CEllis
4 years ago Place Report Server
1.1KViews
0likes
2Comments