Forum Discussion

kelly008's avatar
kelly008
Helper I
3 years ago
Solved

Syntax For ')' Error Message

Hello,   I am currently getting this error message:    Text version:   The syntax for ')' is incorrect. (DAX(VAR OverallStartDate = [OverallStartDate]VAR StartDate = CALCULATE( MIN(Project[...
  • DimaMD's avatar
    DimaMD
    3 years ago

    kelly008  try it

    VAR OverallStartDate = [OverallStartDate]
VAR StartDate = 
CALCULATE( 
MIN(Project[Starting_Date]), 
REMOVEFILTERS(dimDate) 
)
VAR Result = INT(StartDate - OverallStartDate)
RETURN
Result

     

DimaMD's avatar
DimaMD
Solution Sage
3 years ago

kelly008  try it

VAR OverallStartDate = [OverallStartDate]
VAR StartDate = 
CALCULATE( 
MIN(Project[Starting_Date]), 
REMOVEFILTERS(dimDate) 
)
VAR Result = INT(StartDate - OverallStartDate)
RETURN
Result

 

kelly008's avatar
kelly008
Helper I
3 years ago

Amazing thank you!!