The syntax for 'Level' is incorrect.

[AzimiJ]

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)).

[lbendlin · Accepted solution]

[v-pnaroju-msft]

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]

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]

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.

[AzimiJ · Accepted solution]

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

Best!

[lbendlin · Accepted solution]