TOTALYTD is not working

[Anonymous]

I have used the following Dax code for calculating the YTD amount fiscal year starting from April 1.

Sales FYTD = 
CALCULATE (
    [Total FactPriSales],
    DATESYTD (
        DimDate[Date],
        "3/31"
    )
)

But this gives me blank result. This is the model view

 

I have attached sample pbix file. 

Thank you

sample.pbix 

[amitchandak]

@Anonymous ,

For Without slicer.

Please note that when you do NOT use the date slicer of a date filter, then the last date of the calendar will be taken as the date to end YTD.

Now you can stop your calendar today. As this was no created in power BI, You might not able to do that.

You have use filter/slicer in this case.

[amitchandak · Accepted solution]

@Anonymous ,Please find the attached file after the signature. I can see YTD reset after march. Marked Date table as Date table 

[amitchandak]

@Anonymous , This does not seem lik FY starting from April. The one you shared is for FY starting July. Try like

Sales FYTD = 
CALCULATE (
    [Total FactPriSales],
    DATESYTD (
        DimDate[Date],
        "03/31"
    )
)

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a

[Anonymous]

Dear @amitchandak 

You are correct it was a mistake. But still, the code is not working

[CNENFRNL]

Hi, @Anonymous , DATESYTD() evaluates in current context instead of current date. You might want to use this measure to verify its actual range in current context.

test DatesYTD = 
VAR __dates = DATESYTD ( DimDate[Date], "6/30" )
RETURN
    MINX ( __dates, DimDate[Date] ) & UNICHAR ( 10 )
        & MAXX ( __dates, DimDate[Date] )