Forum Discussion

kelly008's avatar
kelly008
Icon for Helper I rankHelper 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
Icon for Solution Sage rankSolution 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
    Icon for Helper I rankHelper I
    3 years ago

    Amazing thank you!!