Date filter is not working with large amount of data
I have a problem and cannot understand the reason.
In the load script my defined date variables are:
LET vServiceStart = Date( MonthStart( today() ) , 'YYYY-MM-DD'); LET vServiceEnd = Date( today() , 'YYYY-MM-DD' );
And the fields in the table, that i compare with are:
createdat, timestamp(createdat,'YYYY-MM-DD hh:mm:ss[.fff] TT') as gmtcreatedat, date#(trim(left(createdat,10)),'YYYY-MM-DD') as gmtcreateddate, ConvertToLocalTime(createdat,'Brisbane') as aestcreatedat, date#(trim(left(ConvertToLocalTime(createdat,'Brisbane'),10))) as aestcreateddate,
I loaded the date like above. I created a pivot table with dimensions: