How to get the number of days until a percentage is met

[LilianaAcosta33]

Hi, 

I have been tasked to calculate the number of days it takes to meet a certain percentage. The user can select the start date using a slicer. 

I have the following data:

In this example, let's say that we want to calculate the number of days it took to hit 4% since the first date, which in this case is 1/1/2018. The result should be 9 days (from 1/1/2018 to 1/10/2018).

Is there a way this calculation can be made?

[LilianaAcosta33]

Just what I needed! thank you so much @grantsamborn 

[grantsamborn · Accepted solution]

Hi @LilianaAcosta33 

Does this help?  (Note that [Characteristice Life] is a measure.)

# of Days = 
    COUNTROWS(
        FILTER(
            ADDCOLUMNS(
                VALUES( 'Table'[Date] ),
                "_tmp", [Characteristic Life]
            ),
            [_tmp] <= .04
        )
    )

pbix: https://1drv.ms/u/s!AnF6rI36HAVkhPIr8MyQISWOyMDXdQ?e=CADtSy