Combine Datasets using Fuller Outer Join - Not getting values as expected

Q&A
, , ,
1

Hi All, Good Morning QS Community.
I have 3 tables like below the screenshot. each connected to a date table of date Column.

image
image897×595 11.7 KB

After joining like above , i am losing some records & getting invalid data values at the visualization level.

  1. Let’s say convert all the above joins into full outer joins, again getting incorrect values at the visual level.
2

Hi @Venkat.Metadata

Please provide your definition from your dataset

Also, show an example of what you say as getting incorrect values at visual level; since you have already determined the problem and what your expected result is.

Regards,
Giri

3

This is Power Bi Data Modelling

image
image1890×878 113 KB

The Data at the Visual - Correct Values
image
image332×303 4.86 KB

The Below is QS Full Join

image
image1130×325 19.3 KB

Data at the Visual level
image
image227×311 13.6 KB

Getting Incorrect Values which are 20 times higher in QS Vs Power BI

4

Hi @Venkat.Metadata

Your QS dataset has full outer-joins across all the tables which explains the issue.

If I follow your Power BI data model you want Left-Join between Calendar Date and your Fact tables (with Calendar being on the left of the join ). Same should be the case with the Reference Line table.

You should be able to change the join type from the Join Type section when you are defining the joins.

image
image1200×226 16.5 KB

5

Hi @Venkat.Metadata,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!