Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Values are not displayed when combining tabala

Hello I have loaded two excel files in POWERBI and I created a single excel table, what I want is to see the PO N. of one excel and the other who was the person who bought it, but when I make the ta...
nandic's avatar
nandic
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Syndicate_Admin could you send screenshot of how you make relationship between tables?
Is it in Power Query using Merge option or in data model using relationships?

If you use Merge option in Power Query, there is option to choose full outer join which will return you all the rows from both tables (both matchin rows and non-matching rows).

 

If you need full outer join using dax, here are some examples:
https://community.fabric.microsoft.com/t5/Desktop/full-outer-join-in-dax/m-p/540609 
https://www.cloudfronts.com/blog/power-bi/full-outer-join-using-dax-in-power-bi/

Cheers,
Nemanja Andic



  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    Hello, thanks for responding.

    I didn't merge table, I just made the relationship in Model View "Reference" is PO in my doc Export and that I related to "PO" in PR-PO Control

    Can I visualize without combining the tables or do I need to combine them?