Forum Discussion
Problem with dates in connected tables
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 cr...
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.
