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 tag...
Need Help
Show and Tell
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