Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Linking table with date table

When I link a table with attribute [date appointment] to my data table, a lot of data gets lost somehow. I've done this with other tables too, but nothing gets lost there. 

 

With link to data table

 

Without link to data table

 

 

 

 

Does anyone know why this might happen?

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Not very clear. Your date appointment table might have timestamp, that can cause date join to fail

     

    create a new date column like

     

    Date = [date appointment].date
    or
    Date = date(year([date appointment]),month([date appointment]),day([date appointment]))

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      This is what I have right now:

       

      Datum =
      ADDCOLUMNS (
      CALENDAR (DATE(2000,1,1), DATE(2025,12,31)),
      "DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
      "Year", YEAR ( [Date] ),
      "Monthnumber", FORMAT ( [Date], "MM" ),
      "YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
      "YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
      "MonthNameShort", FORMAT ( [Date], "mmm" ),
      "MonthNameLong", FORMAT ( [Date], "mmmm" ),
      "DayOfWeekNumber", WEEKDAY ( [Date] ),
      "DayOfWeek", FORMAT ( [Date], "dddd" ),
      "DayOfWeekShort", FORMAT ( [Date], "ddd" ),
      "Quarter", "Q" & FORMAT ( [Date], "Q" ),
      "YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ),
      "WeekNumber",WEEKNUM([Date]),
      "Year WeekNumber", FORMAT ( [Date], "YYYY" ) & "/Week" & WEEKNUM([Date])
      )
      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Anonymous , I think the problem is there with the date appointment has timestamp, Change the data type to datetime and choose a format with time, if you see any other time than 12 AM, it means there is a problem

        Refer I discussed why Time intelligence fails

        https://www.youtube.com/watch?v=OBf0rjpp5Hw