cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Super User I
Super User I

Re: Date Table is not working

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

View solution in original post

Highlighted
Frequent Visitor

Re: Date Table is not working

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
Highlighted
Super User I
Super User I

Re: Date Table is not working

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

View solution in original post

Highlighted
Frequent Visitor

Re: Date Table is not working

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

View solution in original post

Highlighted
Helper IV
Helper IV

Re: Date Table is not working

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

 

 

Still, it is not working..

 

Thanks,

snandy2011

Highlighted
Helper IV
Helper IV

Re: Date Table is not working

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

Highlighted
Helper IV
Helper IV

Re: Date Table is not working

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

Highlighted
Frequent Visitor

Re: Date Table is not working

Good to hear.

 

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

 

What ended up being the issue?

 

 

 

Highlighted
Helper IV
Helper IV

Re: Date Table is not working

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

Highlighted
Helper IV
Helper IV

Re: Date Table is not working

Thanks a lot @Mbp

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors