Current date Flag for fiscal year(starting july)

Hi Everyone,
I need to create a flag to check the completion of fiscal year and include that in a bar chart so that I can display columns for fully completed fiscal years revenue and not to display partial years revenue,

For normal calender year we can write DAX as follows:
IsCurrentYr= IF(Date(Year)=Year(Today()),1,0)

My fiscal year starts in july and ends in june every year.

Can anyone help me on this?

Hi @edna. Hopefully you’re using the Enterprise DNA dates table; if not, add it and you’ll have the fiscal year as well as the calendar year. Hope this helps. Greg

Hi Greg,
I am not using Enterprise DNA table. I have my Calender Table with both Calender and Fiscal Year feilds but I am unable to set the IsCurrent year flag based on Fiscal year. Can it be possible

Would something like this work?

Curr Fisc Yr =
VAR currFiscYr =
CALCULATE(
    MIN( Dates[Fiscal Year] ),
    Dates[Date] = TODAY()
)

RETURN
IF( SELECTEDVALUE( Dates[Fiscal Year] ) = currFiscYr, 1, 0 )

edna Fisc Yr.pbix (37.2 KB)

May be i need to make more changes but thanks for sharing the DAX.

Hello @edna,

Due to the length by which this post has been active, we are tagging it as Solved.

Thanks to the contributors of this post.

For further questions related to this post, please make a new thread. Feel free to reopen this thread if you anyone would like to answer the pending inquiry above.

Thank you