Token Comma Expected

[Anonymous]

Hi all i keep getting the error Token Comma Expected from this query, i cant figure out where the comma is supposed to be. 

Calendar =

GENERATE (

CALENDAR( DATE( 2016,1,1 ) , TODAY()),

VAR startOfWeek = 1 // Where 1 is Sunday and 7 is Saturday, thus a 3 would be Tuesday

VAR currentDay = [Date]

VAR days = DAY( currentDay )

VAR months = MONTH ( currentDay )

VAR years = YEAR ( currentDay )

VAR nowYear = YEAR( TODAY() )

VAR nowMonth = MONTH( TODAY() )

VAR todayNum = WEEKDAY( TODAY() )

RETURN ROW (

"day", days,

"month", months,

"year", years,

"month index", INT( (years - nowYear ) * 12 + months - nowMonth ),

"year index", INT( years - nowYear )

)

)

[mahoneypat]

I put your expression into DAXFormatter.com and it didn't give an error (or fixed it automatically).  Here it is:

Calendar =
GENERATE (
CALENDAR ( DATE ( 2016, 1, 1 ), TODAY () ),
VAR startOfWeek = 1 // Where 1 is Sunday and 7 is Saturday, thus a 3 would be Tuesday
VAR currentDay = [Date]
VAR days =
DAY ( currentDay )
VAR months =
MONTH ( currentDay )
VAR years =
YEAR ( currentDay )
VAR nowYear =
YEAR ( TODAY () )
VAR nowMonth =
MONTH ( TODAY () )
VAR todayNum =
WEEKDAY ( TODAY () )
RETURN
ROW (
"day", days,
"month", months,
"year", years,
"month index", INT ( ( years - nowYear ) * 12 + months - nowMonth ),
"year index", INT ( years - nowYear )
)
)

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

I still get the error message. 

[v-juanli-msft]

Hi @Anonymous @mahoneypat 

I don't get any error.

Could you share error message with me?

Try use ";" to replace "," in your query and check if it is correct.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Weird.  I put it in Power BI and generated your Calendar table w/o error.

Regards,

Pat