Forum Discussion
georgy
7 years agoFrequent Visitor
TOTALYTD is not working
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
1 Reply
- v-chuncz-msft
Community Support
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/