Previous value with criteria

Hi Anonymous ,

I hope I understood your requirement. Typically I highly prefer using measures but in this case I tried it with a calcualted column.

So the following formula identifies in the first place the last relevant row for Nome de Origiem (var_EarlierEntryOfNomeDeOrigem). Based on the time of the last relevant row it gives you back the related value (formula after result).

Value before for name = 

var EarlierEntryOfNomeDeOrigem =
    CALCULATE(
        MAX(fminuto[Timestamp]),
        FILTER(
            ALL(fminuto),
            fminuto[Nome de Origem]=EARLIER(fminuto[Nome de Origem]) 
            && fminuto[Timestamp]<EARLIER(fminuto[Timestamp])
        )
    )


RETURN
CALCULATE(
    SELECTEDVALUE(fminuto[Value],BLANK()),
    FILTER(
        ALL(fminuto),
        fminuto[Nome de Origem]=EARLIER(fminuto[Nome de Origem]) 
        && fminuto[Timestamp] = EarlierEntryOfNomeDeOrigem
    )
)

Please be aware that if there is no or  more than one value for the same time in one category then the formual gives back BLANK(). When there is one distinct previous value for the category (Nome de Origem) then it should work.

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.