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
Date gradi Giorno x lettura1 = if (ISBLANK(Foglio1[Colonna 2]);
VAR LastNonBlankDate =
CALCULATE(LASTNONBLANK(Foglio1[Data];TRUE());FILTER(ALL(Foglio1);Foglio1[Indice] = EARLIER(Foglio1[Indice]) && Foglio1[Data] < EARLIER(Foglio1[Data]) && NOT (ISBLANK(Foglio1[Colonna 2]))))

VAR CurrID = Foglio1[Indice]

RETURN CALCULATE(LASTNONBLANK(Foglio1[Colonna 2]; TRUE());FILTER(ALL(Foglio1);Foglio1[Data] = LastNonBlankDate && Foglio1[Indice] = CurrID));
Foglio1[Colonna 2]
)

 

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

2 Replies

  • 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]
    )