DATESYTD for regulatory year

[Dunner2020]

Hi there,

I am trying to use DATESYTD() in the regulatory year context (The regulatory year starts from 1st April and ends on 31st March). I changed the calculation based on some existing threads to the following:

YTD sum = CALCULATE([Measure], DATESYTD(Dates[Date],"31/3"))

 However, it returns the blank. I assume that its not working as I have already checked [Measure] and it produces the value if 

i did not use with DATESYTD(). Could anyone help me where am I making the mistake?

[selimovd · Accepted solution]

Hey @Dunner2020 ,

depending on your local settings the date could be false. Try maybe to change the end of year date to "3/31".

What always works is to use a regular date, the year will be ignored anyways. So try the following:

YTD sum = CALCULATE( [Measure], DATESYTD( Dates[Date], "2020-03-31" ) )

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic