Forum Discussion

faridelmjabber's avatar
faridelmjabber
Frequent Visitor
6 years ago
Solved

Populate with first non blank

Hello, can someone help me on how can I get the result highlighted in red?     I tried this but without success   [ Spoiler ]   thanks  
Need Help
Show and Tell
  • faridelmjabber's avatar
    faridelmjabber
    6 years ago

    I managed to solve

    thanks

     
    Date gradi Giorno x lettura = if (ISBLANK(Foglio1[Date Letture-Temperature]);
    VAR FirstNonBlankDate =
    CALCULATE(firstNONBLANK(Foglio1[Data];TRUE());FILTER(ALL(Foglio1);
    Foglio1[Data] > EARLIER(Foglio1[Data]) &&
    NOT (ISBLANK(Foglio1[Date Letture-Temperature]))))

    RETURN CALCULATE(firstNONBLANK(Foglio1[Date Letture-Temperature]; TRUE());FILTER(ALL(Foglio1);Foglio1[Data] = FirstNonBlankDate ));
    Foglio1[Date Letture-Temperature]
    )
faridelmjabber's avatar
faridelmjabber
Frequent Visitor
6 years ago

I managed to solve

thanks

 
Date gradi Giorno x lettura = if (ISBLANK(Foglio1[Date Letture-Temperature]);
VAR FirstNonBlankDate =
CALCULATE(firstNONBLANK(Foglio1[Data];TRUE());FILTER(ALL(Foglio1);
Foglio1[Data] > EARLIER(Foglio1[Data]) &&
NOT (ISBLANK(Foglio1[Date Letture-Temperature]))))

RETURN CALCULATE(firstNONBLANK(Foglio1[Date Letture-Temperature]; TRUE());FILTER(ALL(Foglio1);Foglio1[Data] = FirstNonBlankDate ));
Foglio1[Date Letture-Temperature]
)