Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Making Rundown/ burndown curve

Hi,

 

Need your help!

 

I want to create a rundown graph.

I have reamining item that i need to close in 2 week (end of January 2020). working day for a week is 6 days

so i have 12 days till taget date to close remaining item.

 

 i have 35 reamining item to close in 2 weeks, 12 working days (end of January)

i want to make a graph showing how many item need to be closed till the target date as stick graph and line graph which is below.

 

the item list

ITEMIssued DateClosed Date
117/01/202017/01/2020
216/01/2020 
316/01/2020 
414/01/2020 
513/01/2020 
613/01/202017/01/2020
713/01/2020 
813/01/2020 
909/01/2020 
1008/01/2020 
1107/01/2020 
1207/01/202017/01/2020
1307/01/2020 
1404/01/2020 
1503/01/2020 
1602/01/2020 
1702/01/2020 
1802/01/2020 
1930/12/201917/01/2020
2029/12/201917/01/2020
2104/01/2020 
2203/01/2020 
2302/01/2020 
2402/01/2020 
2502/01/2020 
2630/12/2019 
2729/12/2019 
2804/01/2020 
2903/01/2020 
3002/01/2020 
3102/01/2020 
3202/01/2020 
3330/12/2019 
3429/12/2019 
3504/01/2020 
3603/01/2020 
3702/01/2020 
3802/01/2020 
3902/01/2020 
4030/12/2019 

 

this is how my graph want to look like, example graph

Need Help
Show and Tell

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    Anonymous 

     

    Drag [Date] from a calendar table and try measure below.

    Measure =
VAR d =
    MAX ( 'Calendar'[Date] )
VAR d2 =
    MAX ( 'Table'[Closed Date] )
VAR d3 =
    DATE ( 2020, 1, 31 )
RETURN
    IF (
        d >= d2
            && d <= d3,
        ( 1 - DIVIDE ( DATEDIFF ( d2, d, DAY ), DATEDIFF ( d2, d3, DAY ) ) )
            * COUNTROWS ( FILTER ( 'Table', ISBLANK ( 'Table'[Closed Date] ) ) )
    )

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi thanks for the reply.

       

      how do i get the canlendar [date] ?

      Measure = VAR d = MAX ( 'Calendar'[Date] )

       

      Regards,

      CL