cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dparkinson Regular Visitor
Regular Visitor

WEEKNUM in Date Dimension table kills visual? (vis exceeded resources)

Hi,

 

I have a date dimension table created from the date field of my data.  One of the fields in that date table is "WeekNo",WEEKNUM([Date]).

 

When I add this to a table visual, it will no longer display the data (in desktop either actually), giving the "Visual has exceeded the available resources" message in Service and "Can't display the visual" in desktop.

 

The date table only has dates from Jan 1 to Dec 31 2018, and my data only has 3000 rows, so it's not like I have a ton of data or dates causing the issue.

 

Any thoughts anyone has so that I can display this data alongside my other fields would be greatly appreciated.

 

Below is the DAX for my date table at this time:

 

DimDate_ProjectLinesDateCreated = ADDCOLUMNS(
CALENDAR(
  DATE(YEAR(MIN(ProjectLines[CreatedDate])), 1, 1),
  DATE(YEAR(MAX(ProjectLines[CreatedDate])), 12, 31)
),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"MonthNo", FORMAT ( [Date], "MM" ),
"MonthYear", FORMAT ([Date],"MMM-YY"),
"YearMonthNo", FORMAT ( [Date], "YYYY/MM" ),
"YearMonth", FORMAT ( [Date], "YYYY/mmm" ),
"MonthShort", FORMAT ( [Date], "mmm" ),
"MonthLong", FORMAT ( [Date], "mmmm" ),
"WeekDayNo", WEEKDAY ( [Date] ),
"WeekDay", FORMAT ( [Date], "dddd" ),
"WeekDayShort", FORMAT ( [Date], "dddd" ),
"WeekNo",WEEKNUM([Date]),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date],"Q" )
)

Many thanks,

D.

 

1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: WEEKNUM in Date Dimension table kills visual? (vis exceeded resources)

Hi @dparkinson,

 

I can't reproduce your issue. I test with your formula with date column from another table, it works well.(result table has 40k records)

 

Can you please share more detailed information to help us clarify your scenario?

How to Get Your Question Answered Quickly

 

In addition, which version you test? 32bit or 64bit?


Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |