Making Rundown/ burndown curve

[Anonymous]

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

ITEM	Issued Date	Closed Date
1	17/01/2020	17/01/2020
2	16/01/2020
3	16/01/2020
4	14/01/2020
5	13/01/2020
6	13/01/2020	17/01/2020
7	13/01/2020
8	13/01/2020
9	09/01/2020
10	08/01/2020
11	07/01/2020
12	07/01/2020	17/01/2020
13	07/01/2020
14	04/01/2020
15	03/01/2020
16	02/01/2020
17	02/01/2020
18	02/01/2020
19	30/12/2019	17/01/2020
20	29/12/2019	17/01/2020
21	04/01/2020
22	03/01/2020
23	02/01/2020
24	02/01/2020
25	02/01/2020
26	30/12/2019
27	29/12/2019
28	04/01/2020
29	03/01/2020
30	02/01/2020
31	02/01/2020
32	02/01/2020
33	30/12/2019
34	29/12/2019
35	04/01/2020
36	03/01/2020
37	02/01/2020
38	02/01/2020
39	02/01/2020
40	30/12/2019

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

[v-chuncz-msft]

@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]

hi thanks for the reply.

how do i get the canlendar [date] ?

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

Regards,

CL