How to join tables to get expected results

[PowerBI88]

Hi,

I have got the following 3 tables: 

I would like to obtain the following Result table:

Total.Data, Total.Health, Map.Applicativo, Rilasci.DataRilascio

1/02/'21, 100, App1, NuLL

1/03/'21, 80, App2, 22/05/'21

That is, if there is a Release date (Rilasci.DataRilascio) for an application. then write it else put NULL.

At the moment I am unable to properly join or combine the tables that I have to obtain the desired result.

Can you provide me some help in how to achieve that?

Thank you

Kind Regards,

Marta

[v-jingzhang]

Hi @PowerBI88 

You have created relationships between these tables, which columns are they created on in each table? You want to achieve a calculated table or a table visual?

If you want to show these data in a table visual, have you tried adding a table visual in the report and dragging these fields into the visual to display the data? See Table visualizations in Power BI reports and dashboards

Regards,
Community Support Team _ Jing

[PowerBI88]

I would like to create a table visual. I have to perform a sort of left join between Total on columns Data and Map.Applicativo and table Rilasci on columns Data Rilascio, Sistemi Impattati.

The goal is to have a table with the following columns : Total.Data, Total.Health, Map.Applicativo, Rilasci.DataRilascio. I tried also operator "related" but it gives me problems since the cardinality of the relationship is many to many.

Let me know if you need further clarifications.

thank you

Kind regards

[v-jingzhang · Accepted solution]

Hi @PowerBI88 

Can you provide some sample data and expected output in the table visual as well as the relationships between tables? How to provide sample data in the Power BI Forum You can simplify the sample model a bit. As the relationships are many-to-many, what is the logic to match the values from different tables?

As you said left join, have you tried the Merge queries feature in Power Query Editor? It can combine data from two tables into a new table based on one or multiple matching columns. There is Left Outer Join Kind in this feature. You can combine two tables first, then combine the third table to it. When expanding a combined table column, only select the columns you want to have in this new table. 

Reference:

Append vs. Merge in Power BI and Power Query - RADACAD

Merge queries (Power Query) (microsoft.com)

Tutorial: Shape and combine data in Power BI Desktop - Combine queries

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[PowerBI88]

Thank you. I managed to solve my issue by performing a Merge.

[Greg_Deckler]

@PowerBI88 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.