Forum Discussion
TOTALYTD not summing values
Hello I have been using Dax formulas to make Measures in a Power Pivot, the data is connected using Power Query then linked using Data Model in Excel. I cannot work out why TOTALYTD measures are not working, previously the exact same format has worked. I have checked data types and manually checked the dates but each line is showing its distinct value rather than a running total up until and including that date (Fiscal Date).
Please can I have some advice (I have already tried using SUM('Budget Data Fiscal Cal'[Units]) and ALL(('Budget Data Fiscal Cal'[Fiscal Date])).
Thanks!
3 Replies
- amitchandak
Super User
caitlindrake_ , Make sure you are using data from a date table marked as date table
Totalytd( SUM('Budget Data Fiscal Cal'[Units]) , 'Date'[Date])
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.Thank you for your responses, I have tried your suggestions and unfortunately still not getting any sum values.
- Ashish_Mathur
Hi,
In addition to what Amit has suggested, ensure that, to your visual, you drag Date from the Date table.
