Forum Discussion
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", 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" )
)
But, when i am using any column of this table for my visualization, it is showing nothing. I am attaching a screenshot for better understanding,
So for that, I wont be able to make any visualization,slicer and wite any formula using this date table.
Please help me to solve this problem. What wrong I have done?
Please answer.
Thanks,
snandy2011
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?
8 Replies
I assume you have related your date table to your main data table?
jthomson , I have solved my problem. It is working right now. Thank you very much for your kind reply.
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?
