Fiscal Year measure

[PowerBI_M]

Hi,

I want to create a measure in PowerBI for fiscal year. I am starting with PowerBI, so my experience is very limited.

This gives a syntax error:

FiscalYear_ = IF(MONTH(NOW()) <= 9, YEAR(NOW()); YEAR(NOW()) + 1) 

What am I doing wrong here?

Thanks a lot for your help!

KR M

[cpearson]

Your error is likely because of the semi colon in there... it should be a comma.

Also check out the CALENDARAUTO function as it could be useful to you.

Regards

Carl