Not able to use Calendar Table

[Victormar]

Hi community,

I have been dealing for some days with a problem when connecting a calendar table I create to some data tables that I have within my model. I have never experienced this problem, so I don't really know what can be wrong.

I have several tables with data regarding vehicles, ranging from some parameters that we collect data from, to a list of delivered vehicles, to a table with Reading_ids. All of these tables have a timestamp.

What I am trying to do is to create a separate table for calendar/hierarchies purposes, but when I connect the date column with the tables, it won't display any data, like if the connection wouldn't work. 

I tried two different way to create the calendar table, and I never had problems before with them. One would be a pre-created formula like:

Optimum calendar =
VAR PrimeraFechaVentas = MIN(This I would change for the main date column) ---> Columna a cambiar
VAR AnoPrimeraVenta = YEAR(PrimeraFechaVentas)
VAR Fechas =
FILTER(
CALENDARAUTO(),
YEAR( [Date]) >= AnoPrimeraVenta
)
RETURN

ADDCOLUMNS(
Fechas,
"Año", YEAR([Date]),
"Trimestre", FORMAT([Date], "\QQ"),
"MesNumerico", MONTH([Date]),
"Mes de año", FORMAT([Date], "mmm"),
"Mes", FORMAT([Date], "mm"),
"DiaSemanaNum", WEEKDAY([Date],2),
"Dia Semana", FORMAT([Date], "ddd")
)

The other one would be just clicking on entering data to create a new column, manually putting which is the first date, creating another column using M language defining the last date, which would be today's date, and getting all the range of days between both dates.

My main problem is, why is not working when connecting both dates, from the calendar table to the other tables? Never happened before.

Thnaks in advance 🙂

[Victormar]

Indeed! That was actually the problem, in the Power Query one of the Date columns was marked as Date/Time, many thanks!

[moizsherwani · Accepted solution]

@Victormar I can't say exactly without looking at your data model but when I faced this issue in the past, it was because the date column were different (even though they looked the same). E.g. one might be coming through as a datetime and the other as a date so PowerBI doesn't understand that 1/1/2022 is the same as 1/1/2022 00:00. Let me know if this helps. If not please try to send over the data model with the two tables in question.