Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear All,
I have three table as confirmed, recovered & death.
When i try to merge all table together i get null value under recovered column of the merged table data.
Attached here with the pbix file for your reference.
<iframe src="https://onedrive.live.com/embed?cid=B52CAD1EB6C3FE36&resid=B52CAD1EB6C3FE36%21166&authkey=AIoettQaUa..." width="98" height="120" frameborder="0" scrolling="no"></iframe>
Thanks in advance.
Best Regards,
Shib
Solved! Go to Solution.
Hi @coolshib ,
First thing I don't see Null values in the CONSOLIDATED table under RECOVERED column. I see BLANKS.
The reason for blank values is for the rows with this combination, you don't have data in REcovered table of yours. For eg:
Province/State = "Prince Edward Island"
Country/Region = "Canada"
Date = "30 March 2020"
There is no data for above combination in RECOVERED table.
Lets talk about how your joins are done:
1. Confirmed LEFT OUTER JOIN Deaths = OUTPUT_first
2. OUTPUT_first LEFT OUTER JOIN Recovered
This suggests there are some rows in OUTPUT_first which don'e exist in Recovered table. Therefore ends with BLANKS.
Also, I can't navigate through your Edit Query steps to view result at each step as it uses some DB credentials. It will be helpful to have this .pbix file without DB credentials.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @coolshib ,
First thing I don't see Null values in the CONSOLIDATED table under RECOVERED column. I see BLANKS.
The reason for blank values is for the rows with this combination, you don't have data in REcovered table of yours. For eg:
Province/State = "Prince Edward Island"
Country/Region = "Canada"
Date = "30 March 2020"
There is no data for above combination in RECOVERED table.
Lets talk about how your joins are done:
1. Confirmed LEFT OUTER JOIN Deaths = OUTPUT_first
2. OUTPUT_first LEFT OUTER JOIN Recovered
This suggests there are some rows in OUTPUT_first which don'e exist in Recovered table. Therefore ends with BLANKS.
Also, I can't navigate through your Edit Query steps to view result at each step as it uses some DB credentials. It will be helpful to have this .pbix file without DB credentials.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |