Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
snandy2011
Helper IV
Helper IV

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,

 

 

Screenshot (1).png

 

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

 

 

 

2 ACCEPTED SOLUTIONS
jthomson
Solution Sage
Solution Sage

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

View solution in original post

Mbp
Frequent Visitor

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

View solution in original post

8 REPLIES 8
Mbp
Frequent Visitor

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?

 

 

 

Thanks a lot @Mbp

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

jthomson
Solution Sage
Solution Sage

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

@jthomson Yes, I have already related. see below imageScreenshot (2).png

 

 

Still, it is not working..

 

Thanks,

snandy2011

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.