Forum Discussion

MSiwek's avatar
MSiwek
Helper I
1 year ago

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...
Need Help
danextian's avatar
danextian
Super User
1 year ago

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's avatar
    MSiwek
    Helper I
    1 year ago

    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's avatar
      danextian
      Super User
      1 year ago

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

      • MSiwek's avatar
        MSiwek
        Helper I
        1 year ago

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