Formula to return a Date categorized a certain way in the Date Dimension?

[Anonymous]

I have a Date Dimension table that spans several years. 

We're on a fiscal year July - June.

I am trying to make a formula that will return the first day of the next fiscal year. 

Ex: today, the first day of the next fiscal year is 7/1/21. On July 1, the first day of the next fiscal year will be 7/1/22.

Any ideas on how I could do this?

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below measure. It is a calculated measure.

next fiscal year start date =
VAR currentmonth =
MAX ( dates[Month] )
VAR currentyear =
MAX ( dates[Year] )
VAR nextfiscalyear =
IF ( currentmonth <= 6, currentyear, currentyear + 1 )
RETURN
DATE ( nextfiscalyear, 7, 1 )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.