Forum Discussion
How to display future dates
Hi aramirez7
Thanks a lot for answering. I´m kind of lost on how to effectively operate your solution.
The 'Source' would be the calendar table or a metric? Or should it be written in the Power Query Editor?Well, I already got a way to make the chart display all days using a measure combined with the ALLSELECTED statement.
Thank you very much!
1. Create a calendar table with the number of future days you want, see this ejm with 15 future days
let
Source = #date(
Date.Year( DateTime.LocalNow())-1,1,1),
allDates = List.Dates(Source, Number.From(DateTime.LocalNow())+15 - Number.From(Source) ,#duration(1,0,0,0))
in
allDates
2. Change the TOTALYTD function to something like:
Annual cumulative =
VAR startDate = DATE(YEAR(TODAY()),1,1)
VAR endDate = MAX( Dates[Date])
Return, New
CALCULATE,[Puntos planed daily],
FILTER( ALL( Dates ),
DATESBETWEEN(calendar_dim[dateKey],startDate, endDate)
)
I'd think that might work for you, greetings.
Hi aramirez7
Thanks a lot for answering. I´m kind of lost on how to effectively operate your solution.
The 'Source' would be the calendar table or a metric? Or should it be written in the Power Query Editor?
Well, I already got a way to make the chart display all days using a measure combined with the ALLSELECTED statement.
Thank you very much!