Duplicate data after merging tables with left outer join

[Anonymous]

i am getting duplicate data after merging tables with left outer join.

I have merged SCD table with Fondsatellite with left outer join

Similarly I have joined newly merged scd table with another merged table (Fund satellite and summary list) with left outer join.

What is the reason I am getting  exactly duplicate data ? Its not duplicate but doubled up..The actual results should be exactly half of what is showing

[v-yulgu-msft]

Hi @Anonymous ,

Please provide some dummy data in source table so that I can reproduce the same scenario on my side. Besides, are all fields shown in above table visual original columns in data table or calculated measures?

Regards,

Yuliana Gu