Forum Discussion
Line chart
Hej, for some reason the curve shows the same values for future months for which we have not yet entered data into the Excel. Even there are not even empty cells for this data In the second pi...
angelina_tr This approach will display Sales, for example, only up until the year to date:
Create a ytd_dates column in your date table (or data table depending on your model):
ytd_dates =
IF (
[Month] <= TODAY (),
1,
0
)
Then create a YTD Sales measure (or Cumulative reach measure in your case):
YTD Sales =
CALCULATE (
TOTALYTD ( SUM ( Sheet1[Sales] ), Sheet1[Month], "12/31" ),
KEEPFILTERS ( Sheet1[ytd_dates] = 1 )
)