Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Right Join in Power bi Tabular view

Hi Team, I have two sample tables here named Cust and Invoice the relationship in power bi desktop is many to many Now i want to create a tabular view with Date, Custid, Cust name,...
Need Help
  • jaideepnema's avatar
    jaideepnema
    5 years ago

    Hi Anonymous ,

    As per my understanding the only way to achieve this is through Merging.

jaideepnema's avatar
jaideepnema
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Anonymous ,

The Invoice Amount cannot be shown as the corresponding customer ID are not available in the Customer Table. In your case for the three dates ie: 15th,16th and 17th January 2021 the customer IDs 16,17 and 18 are not available in the Customer Table. Since these are not available you can only show them as blank. 

 

 

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos ðŸ˜€

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Exactly i want to show them as blanks in the tabular view 

    the output i want is 



    is this possible to show in power bi??

    • jaideepnema's avatar
      jaideepnema
      Icon for Solution Sage rankSolution Sage
      5 years ago

      Hi Anonymous ,

      You can merge the two tables as shown below and then expand the columns required from the merged table:

      Use this merged table to create the table required.

      Please accept this as a solution if your question has been answered !!

      Appreciate a Kudos ðŸ˜€

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks Jaideep

        seems like merging is the only way, is not it ?