How to display future dates

[andrekroker]

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?

[aramirez7]

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.

[andrekroker · Accepted solution]

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!