TOTALYTD is not working

[georgy]

Hi,

TotalYTD function does not return the right value for me. I have DATE table which is linked to other tables.

I have the following data:

1. Sales Actual

2. Sales F-1 FY 20 Forecast 

3. Sales F-2 FY 20 Forecast

I created a measure Sales FSCT that uses Sales ACT and if Actual Sales are zero then Sales F-2 FY20 FCST is used. 

Then I added Sales YTD FCST = TOTALYTD(Sales FCST, Date, "31/03") but as you can see from photo it stops adding sales when Sales ACT is zero, even though Sales FCST measure shows the right numbers.

Can anyone help please.

Cheers

[v-chuncz-msft]

@georgy 

Take a good look at link below to have a better understanding of time intelligence function.

https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/