topic Re: The syntax for 'Level' is incorrect. in DAX Commands and Tips

The syntax for 'Level' is incorrect.

AzimiJ — Wed, 23 Apr 2025 17:02:42 GMT

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

Re: The syntax for 'Level' is incorrect.

lbendlin — Wed, 23 Apr 2025 19:06:52 GMT

Re: The syntax for 'Level' is incorrect.

AzimiJ — Wed, 23 Apr 2025 19:35:56 GMT

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

Best!

Re: The syntax for 'Level' is incorrect.

v-pnaroju-msft — Mon, 28 Apr 2025 09:49:10 GMT

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.

Re: The syntax for 'Level' is incorrect.

v-pnaroju-msft — Thu, 01 May 2025 17:42:59 GMT

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.

Re: The syntax for 'Level' is incorrect.

v-pnaroju-msft — Sun, 04 May 2025 18:42:00 GMT