Forum Discussion
ljkeefe
Helper II
Helper IIError message: The syntax for ')' is incorrect.
I'm following this tutorial step-by-step and I get the syntax error: https://www.youtube.com/watch?v=cdUg8LfarCg&lc=UgxiYG9l4FEGSPPCHIZ4AaABAg.9ojUaHLyeGS9ol4f4SkqIS
Here's my code:
PaddingLeft =
VAR OverallStartDate1 = [OverallStartDate]
VAR StartDate =
CALCULATE (
MIN ('Required Messaging Schedules'[Project Start Date]),
REMOVEFILTERS (DateTable)
)
VAR Result =
INT(StartDate - OverallStartDate1)
RETURN
I'm at a loss. I've rewatched the video three times.
You need to tell it what to return.
PaddingLeft = VAR OverallStartDate1 = [OverallStartDate] VAR StartDate = CALCULATE ( MIN ('Required Messaging Schedules'[Project Start Date]), REMOVEFILTERS (DateTable) ) VAR Result = INT(StartDate - OverallStartDate1) RETURN Result
3 Replies
- jdbuchanan71
Super User
You need to tell it what to return.
PaddingLeft = VAR OverallStartDate1 = [OverallStartDate] VAR StartDate = CALCULATE ( MIN ('Required Messaging Schedules'[Project Start Date]), REMOVEFILTERS (DateTable) ) VAR Result = INT(StartDate - OverallStartDate1) RETURN Result
ljkeefeOh my god...I came across a post that said to use Return_result and that didn't work. But I just tried your suggestion and BAM! Thank you!
- jdbuchanan71
You are returning your variable so if you had called your variable 'MyResult' instead of Result you would
Return
MyResultGlad you got it working.