the start date cannot be later than the end date

[mina97]

i wrote the following DAX code to insert a new column 

workdays =

var TBL_DATE=CALENDAR('RPT_GHAD_PERFORMANCE'[TASK_START_DATE],RPT_GHAD_PERFORMANCE[TASK_END_DATE])

var TBL_FINALDATE= ADDCOLUMNS(TBL_DATE,"WorkingDate",IF(WEEKDAY([Date],1)>=6,0,1))

return

SUMX(TBL_FINALDATE,IF([WorkingDate]=1,1,0))

and it used to work but i entred the page and i have the following message that says cant display the visual because the start date cannot be later than the end date 

please help 

[olgad · Accepted solution]

Hi,
do the data validation, may be you got an incorrect entry after the refresh. 
Create a calculated column,  Start date > End date and filter for TRUE, to see which entry is causing you that issue. 

Best Regards