cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

How to display future dates

Hi all()

Given the following table and Line Chart and considering:
- Sprint ends on May,25th

BurnUp ChartBurnUp 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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: How to show 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!

View solution in original post

2 REPLIES 2
Highlighted
Frequent Visitor

Re: How to show future dates

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.

Highlighted
Helper III
Helper III

Re: How to show 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!

View solution in original post

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

August Community Highlights

Check out a full recap of the month!

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors