EOF TOKEN EXPECTED WARNING in DAX FORMULA

[Anonymous]

FiscalMonthStartDate =
VAR CalendarYear = YEAR('Calendar'[Date])
VAR FiscalYearStartMonth = 8
RETURN
IF(
MONTH('Calendar'[Date]) >= FiscalYearStartMonth,
DATE(CalendarYear, MONTH('Calendar'[Date]) - 7, 1),
DATE(CalendarYear - 1, MONTH('Calendar'[Date]) + (12 - FiscalYearStartMonth + 1), 1)
)
Hi,
I am trying to write a formula like that but I get a eof token expected warning. How can I solve that? Thank you.

[Anonymous · Accepted solution]

Hi @Anonymous ,

If you create a calculated column, this dax outputs as expected.

If you create a measure, modify the dax as follows:

Measure_FiscalMonthStartDate = 
VAR CalendarYear = YEAR(MAX('Calendar'[Date]))
VAR FiscalYearStartMonth = 8
RETURN
IF(
MONTH(MAX('Calendar'[Date])) >= FiscalYearStartMonth,
DATE(CalendarYear, MONTH(MAX('Calendar'[Date])) - 7, 1),
DATE(CalendarYear - 1, MONTH(MAX('Calendar'[Date])) + (12 - FiscalYearStartMonth + 1), 1)
)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.