Year to Date calculation for Financial Year(July1st2019-June30th 2020)

[chiru5262]

Hi,

I would like to calculate Year to date for Financial Year((July1st2019-June30th 2020)

How can I modify my dax measure accordingly.

Please advise.

Regards,

Chiru

[ThomasFuchs]

Hi @chiru5262 ,

in your case I recommend to use TOTALYTD:

TOTALYTD(SUM(Amount) , 'Date'[Date], "6/30")

Details see: https://docs.microsoft.com/en-us/dax/totalytd-function-dax

BR,

Thomas

[Anonymous]

Hi @chiru5262,

Hope this link helps u

https://www.powerobjects.com/blog/2018/12/19/sorting-data-fiscal-year-power-bi/ 

Regards
Sac