Forum Discussion
Solved
Date Table is not working
Hi All, I have made a Date table by that formula, Datetable = ADDCOLUMNS(CALENDAR("25-09-2013","18-01-2018"),"Year",YEAR([Date]),"Monthnumber",FORMAT ( [Date], "MM" ), "YearMonthnumber", ...
I assume you have related your date table to your main data table?
Is the date table not working on it's own or only when used with the Demo table?
Is the date table not working on it's own or only when used with the Demo table?
Mbp In both cases..
The date table is not working on it's own and also with the demo table (when i use it with demo table)
Good to hear.
Your script for the date table worked fine for me when I used it.
What ended up being the issue?
Mbp I forgot to change the data type of the date column of the main table in the query edior.
