Calendar based on another table not quite working

[Anonymous]

I have an odata feed that retrieves the start and end dates

= OData.Feed(#"Http/Https" & "://" & #"Analytics URL/Azure DevOps Server" & "/" & Organization & "/" & Project & "/_odata/v3.0-preview/WorkItemSnapshot?%20$apply=filter(%20WorkItemType%20ne%20%27Issue%27%20and%20WorkItemType%20ne%20%27Task%27%20and%20WorkItemType%20ne%20%27Test%20Case%27%20and%20WorkItemType%20ne%20%27Test%20Plan%27%20and%20WorkItemType%20ne%20%27Shared%20Parameter%27%20and%20WorkItemType%20ne%20%27Shared%20Steps%27%20and%20WorkItemType%20ne%20%27Test%20Suite%27%20and%20WorkItemType%20ne%20%27Impediment%27%20and%20DateValue%20ge%20Iteration/StartDate%20and%20DateValue%20le%20Iteration/EndDate%20and%20Iteration/StartDate%20le%20now()%20and%20Iteration/EndDate%20ge%20now()%20)%20/groupby(%20(DateValue,StateCategory,StoryPoints,IterationSK,State,WorkItemType,WorkItemID,ParentWorkItemID,Area/AreaPath,Iteration/IterationPath),%20aggregate($count%20as%20Count)%20)", null, [Implementation="2.0"])

I have created a calendar table based on this

SprintDays = CALENDAR(MIN('Burndown'[DateValue]), MAX('Burndown'[DateValue]) )

My question is this... since the EndDate is in the future, how would you get the SprintDays table to display future dates with no data in them?
I 
 

[Anonymous]

Here is the file.. maybe that will help? @amitchandak and @Anonymous ?  Maybe if I populated the future dates with the ideal burn down data (ie, the sum of all the story points or stories from day one of the sprint divided by 10 (working days in a sprint) across the future dates?)

sprint burndown 

[Anonymous]

Hi  @Anonymous ,

Does your Burndown'[DateValue] originally only have data from 2022.8.28 to 2022.9.7?

You can manually set the EndDate for the table

SprintDays =
CALENDAR(MIN('Burndown'[Date]),DATE(2022,12,31))

Join the relationship between two tables:

Result：

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Thanks! I was hoping to avoid doing it manually and it automatically as I would need to set the end date every two weeks all year.

[Anonymous]

I don't understand what I'm doing wrong sir....

[amitchandak]

@Anonymous , if 'Burndown'[DateValue] is in the future, you should get future dates. If need you can take max of more than one date 

example

SprintDays = CALENDAR(MIN('Burndown'[DateValue]), MAx(MAX('Burndown'[DateValue]),MAX('Burndown'[DateValue2]))  )