Linking table with date table

[Sohan]

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?

[amitchandak]

@Sohan , 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]))

[Sohan]

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]

@Sohan , 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

[Sohan]

Hi @amitchandak, I had [date appointment] in Power Query as date, not timestamp. So it probably shouldn't be that.