DATESYTD - SET fiscal year is 1 July to 30 June

[CNH]

DATESYTD(Dates[Date]) - defaults to December 31, how do I change this so that the fiscal year is 1 July to 30 June

I have the following measure

Annlzd RoR % YTD = CALCULATE([Annlzd RoR], DATESYTD(Dates[Date]))

The DATESYTD defaults to a calendar year however I wish to calculate the measure based on a 1 July to 30 June calendar year.

Can I ask for support on modifying this code or provide insight as to how to get this as an outcome.

Thanks

[Interkoubess · Accepted solution]

@CNH,

Please use this formulas depending on your date fomrat:

Annlzd RoR % YTD = CALCULATE([Annlzd RoR], DATESYTD(Dates[Date],"06-30"))

Or Annlzd RoR % YTD = CALCULATE([Annlzd RoR], DATESYTD(Dates[Date],"06/30"))

Hope it helps.

Ninter

[CNH]

Ninter, perfect. Thank you