Forum Discussion

mina97's avatar
mina97
Icon for Helper III rankHelper III
2 years ago
Solved

the start date cannot be later than the end date

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 
 
"Dates"
"DAX help"
Advance DAX
  • olgad's avatar
    olgad
    2 years ago

    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


     

1 Reply

  • olgad's avatar
    olgad
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    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