The following syntax error occurred during parsing: Invalid token, Line 1, Offset 121, ​.

[dpate46]

I am not sure how to fix this error. Please Help.

All I am trying to do is to fetch the max date from column "opendate" where the column "credited_branch" is not equal to "00000". Please let me know if there is an alternative way to achieve it with DAX. Thanks!

[h11]

@amitchandak 

I'm facing the similar error on my power Bi when I'm trying to type a measure. The error is "The following syntax error occurred during parsing: Invalid token, Line 5, Offset 46,. Please help.

Thank you!

[h11]

@amitchandak I'm facing the similar error on my power Bi when I'm trying to type a measure. The error is "The following syntax error occurred during parsing: Invalid token, Line 5, Offset 46,. Please help.

Thank you!

[amitchandak · Accepted solution]

@dpate46 , Should have worked

Try like

calculate(Max(Table[opendate]) , filter(Table, Table[credited_branch] <> "00000" ) )