Forum Discussion
How to display future dates
Hi all()
Given the following table and Line Chart and considering:
- Sprint ends on May,25th
BurnUp Chart
I want both table and line chart to show the Daily Pace till the end of the sprint.
These are the measures related do Daily Pace I have so far:
- Daily Pace = TOTALYTD ([Pontos Planejados Diários],table[Date],Table[Date],"25/05")
- Pontos Planejados Diários = SUMX(table, [3.1 Total User Story (Pontos)] / [Total Sprint Days])
And I have the Sprint End Date as a column in my Table data.
How do I do this?
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!
2 Replies
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!
