Problem with dates in connected tables

[MSiwek]

Hello, I have a problem with connected tables which are connected by SVCCREATEDBY (TABLE 1) to Column1 (TABLE 3) and TABLE 3 is connected to TABLE 2 also by same thing like in TABLE 1. TABLE 3 was created as new query from TABLE 1 and TABLE 2 because there are duplicates (it's correct) so I made a table without duplicates to have a key to join tables, and that's working.

My problem is when I'm trying to use something from TABLE 1 with SVCCREATED and values from TABLE 2 the chart/table shows bad values. 

So I know there are something wrong with dates, maybe it's a problem because data in TABLE 1 is from Oracle data base but data from TABLE 3 is from Microsoft data base? Also you should know that "Data" Column in TABLE 2 is made from = Table.AddColumn(#"Niestandardowe1", "Data", each #date([YearNumber],[MonthNumber],[DayNumber])) and formatted as data in PQ.

[bluedatenbrian]

Look on table view (on Power BI Desktop) and on each fields proprieties. All 3 fields must be equal (date at this case). 

Why do you need your table 2? Is it a dimention? If it is, both relationship should be single direction (avoid bi-directional relationship every time you can). 
If you need to use some field from table 1 to summarize data from table 3, table 1 looks like a dimenson to table 3, why don't you relate then directly? I'd create a dimension based on this field to link to both tables.

As simple you can keep your model, easier it will be to create your measures and visuals, also you will have better performance on its data refresh and report usage.

[MSiwek]

As you can see in TABLE 1 key is SVCREATEDBY which have duplicates and it's correct, same thing is in TABLE 2 so i decided to made a TABLE 3 which contains only unique values from both tables. 

[danextian]

Hi @MSiwek 

Could you please provide a sample of your data along with the expected results, including the reasoning behind them? You may share a link to a non-confidential version that closely represents your data or a sanitized copy of your PBIX file.

[MSiwek]

Hi @danextian, I don't know why but I can't attach xlsx and pbix, Screen attached. So for example I would like to see the same data in two tables made in PowerBi using data from different tables. I know that in Table 3 I don't have any other month than december but it doesn't matter in that case, the results are the same even if I have 1:1 dates.

Table1:

Table 3:

Connection:

Niestandardowe means data from = Table.AddColumn(#"Niestandardowe1", "Data", each #date([YearNumber],[MonthNumber],[DayNumber])) and formatted as data in PQ.

Table made using SVCDATECREATED:

Table made using Niestandardowe:

As you can see first table is good but second is incorrect because all data are agregated to just december.

[danextian]

You may post a link to a file in the cloud.

[MSiwek]

Honestly, I'm unable to share on cloud due to organizational policy.