Date Table is not working

[snandy2011]

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

[jthomson · Accepted solution]

I assume you have related your date table to your main data table?

[Mbp · Accepted solution]

Is the date table not working on it's own or only when used with the Demo table? 

[snandy2011]

@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)

[Mbp]

Good to hear.

Your script for the date table worked fine for me when I used it.

What ended up being the issue?

[snandy2011]

Thanks a lot @Mbp

[snandy2011]

@Mbp I forgot to change the data type of the date column of the main table in the query edior.

[jthomson · Accepted solution]

I assume you have related your date table to your main data table?

[snandy2011]

@jthomson Yes, I have already related. see below image

Still, it is not working..

Thanks,

snandy2011

[snandy2011]

@jthomson , I have solved my problem. It is working right now. Thank you very much for your kind reply.