Forum Discussion
TotalYTD formula not working
Hi,
I am working on a sales rep view for sales YTD.
My Sales YTD Measure works correctly when adding to the total of 40.71 mil. But when I try to break it down by month on a line graph it is including numbers from last year for months that havent happened in 2024 yet. How do I get rid of sept-dec?
My Sales YTD = TOTALYTD([Sales Total], 'Sales Data'[InvoiceDATE])
Hi! I am assuming that in your line graph you have a measure for sales, rather than YTD so that is is not showing the cumulative total?
In this line chart I have the sales by month:
In the filter pane, if I put the date filter to relative and say that it is in this year, the future months go away:
2 Replies
- audreygerred
Super User
Hi! I am assuming that in your line graph you have a measure for sales, rather than YTD so that is is not showing the cumulative total?
In this line chart I have the sales by month:
In the filter pane, if I put the date filter to relative and say that it is in this year, the future months go away: