Forum Discussion

AzimiJ's avatar
AzimiJ
Regular Visitor
1 year ago
Solved

The syntax for 'Level' is incorrect.

Hello all,

Please help me know the issue and fix it. Thank you all!

ProjectedTF =
VAR Alpha = 0.6
VAR Beta = 0.4
VAR Last4Actual = CALCULATE([Last4ActualWednesdays], ALL('DateTable'))
VAR LastYearAvg = CALCULATE([LastYearSameWeekday], ALL('DateTable'))
VAR Level = Alpha * Last4Actual + (1 - Alpha) * LastYearAvg
VAR Trend = Beta * (Last4Actual - LastYearAvg)
RETURN
    Level + Trend

---
The syntax for 'Level' is incorrect. (DAX(VAR Alpha = 0.6VAR Beta = 0.4VAR Last4Actual = CALCULATE([Last4ActualWednesdays], ALL('DateTable'))VAR LastYearAvg = CALCULATE([LastYearSameWeekday], ALL('DateTable'))VAR Level = Alpha * Last4Actual + (1 - Alpha) * LastYearAvgVAR Trend = Beta * (Last4Actual - LastYearAvg)RETURN Level + Trend)).

5 Replies

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    1 year ago

    Thankyou, lbendlin, for your response.

    Hi AzimiJ,

    We are pleased to learn that your issue has been resolved. Kindly mark the response that resolved your query as the accepted solution, as this will help other community members facing similar challenges to find solutions more effectively. Please feel free to continue using the Fabric Community for any further assistance with your queries.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    1 year ago

    Hi AzimiJ,

    We are pleased to learn that your issue has been resolved. Kindly mark the response that resolved your query as the accepted solution, as this will help other community members facing similar challenges to find solutions more effectively. Please feel free to continue using the Fabric Community for any further assistance with your queries.

    Thank you.

  • AzimiJ's avatar
    AzimiJ
    Regular Visitor
    1 year ago

    Thank you Ibendlin,
    I have changed Level and Trend to TheLevel and TheTrend, issue resolved.

    Best!

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    1 year ago

    Hi AzimiJ,

    We are pleased to learn that your issue has been resolved. Kindly mark the response that resolved your query as the accepted solution, as this will help other community members facing similar challenges to find solutions more effectively. Please feel free to continue using the Fabric Community for any further assistance with your queries.

    Thank you.