Burndown Chart - Dynamically Created Table??

[titanconsulting]

All,

I've looked through examples and haven't figured this out yet.  Trying to build burndown chart for PMO dashboard (so it will have tons of projects at once.  I'll have slicers for Project, Sprint, and Sprint Team (steam) and want to show burndown chart based on those slicers. 

I have a sprint table that describes start and end date

I have requirements - fields include Status, Points, Close Date (just showing important fields)

I know I need to create a dynamic table of days during the filtered sprint (from sprint start to end date).  That table then would need total story points, ideal points for the day, and actual points for the day.  I can create the visual from there - but the build of the dynamic table is going over my head???

Thanks in advance for any help.

[titanconsulting]

Thanks to both of you - created a new table and then used the calendar in order to create the table.

[amitchandak · Accepted solution]

@titanconsulting 

Refer if this can help :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Greg_Deckler]

So, you cannot build an actual table table that is dynamic because tables are only calculated at run time. You essentially have to build the table dynamically within the measure. I actually have an example of a dynamic burnd down chart in my new book, DAX Cookbook, that is very similar to what you have here. Now, sample data as text would have been great, I probably could have whipped up a quick example PBIX. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

In general, the way to go about this is something like:

Burndown Measure =
  VAR __Table = 
    CALENDAR(
      MAX([StartDt]),
      MAX([EndDt])
    )
  VAR __Table1 =
    ADDCOLUMNS(
      __Table,
      "Some column",<some calculation goes here probably involving hours for dates>
    )
RETURN
  SUMX(__Table1,[Some column])

So, not 100% sure what you are going for, but essentially you can build a dynamic table within a meausure using CALENDAR or GENERATESERIES, add columns to it to do your calculations and then aggregate across that dynamic table.