Calculate first day when value is greater than start value

[Oopa]

Hi,

I try to generate measure which should return first date where cumulative amount is greater than start value. I did measure 

First_date = CALCULATE(FIRSTDATE(Cumulative_amount[Date]);FILTER(Cumulative_amount;Cumulative_amount[Cumulative_amount]>Start_amount[Start_value_amount])) but this gives the results below which are not correct. E.g for date 2.1.2020 I would like to see 17.1.2020 etc.

[v-frfei-msft · Accepted solution]

Hi @Oopa ,

We should create a measure as below to work on it.

Measure = 
IF (
    SUM ( Start_amount[Start_value_amount] ) = BLANK (),
    BLANK (),
    CALCULATE (
        MIN ( 'Cumulative_amount'[date] ),
        FILTER (
            ALL ( Cumulative_amount ),
            Cumulative_amount[Cumulative_amount] > SUM ( Start_amount[Start_value_amount] )
        )
    )
)

For more details, please check the pbix as attached.

[Oopa]

Thank you very much it works perfectly!