Forum Discussion

renanc's avatar
renanc
Icon for Helper II rankHelper II
4 years ago
Solved

Calculate the values between two lines

Hi everybody, I have a calculated value on Dax, but it calculates the value between the current fuel fill and the next one. I want to calculate the value between the current fuel fill and the previou...
  • renanc's avatar
    renanc
    4 years ago

    Hi Anonymous I found the solution for this case, it was:

    KM Anterior =
    VAR Ultimo_Checklist =
    CALCULATE(
    MAX(fChecklists2[IdChecklist]),
    FILTER(
    ALL(fChecklists2),
    (fChecklists2[DescPlaca])=EARLIER([DescPlaca])
    && fChecklists2[IdChecklist] < EARLIER([IdChecklist])
    && fChecklists2[IdQuestionario] = EARLIER([IdQuestionario])
    && fChecklists2[DtCadastro] <= EARLIER([DtCadastro])
    )
    )

    VAR KM_Anterior =
    CALCULATE(
    MAX(fChecklists2[Digite a KM]),
    FILTER(
    ALL(fChecklists2),
    fChecklists2[IdChecklist] = Ultimo_Checklist
    )
    )

    RETURN
    KM_Anterior
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi renanc ,

 

Please share some sample data so that we could test the formula on it.

 

Best Regards,

Jay

  • renanc's avatar
    renanc
    Icon for Helper II rankHelper II
    4 years ago

    Hi Anonymous I found the solution for this case, it was:

    KM Anterior =
    VAR Ultimo_Checklist =
    CALCULATE(
    MAX(fChecklists2[IdChecklist]),
    FILTER(
    ALL(fChecklists2),
    (fChecklists2[DescPlaca])=EARLIER([DescPlaca])
    && fChecklists2[IdChecklist] < EARLIER([IdChecklist])
    && fChecklists2[IdQuestionario] = EARLIER([IdQuestionario])
    && fChecklists2[DtCadastro] <= EARLIER([DtCadastro])
    )
    )

    VAR KM_Anterior =
    CALCULATE(
    MAX(fChecklists2[Digite a KM]),
    FILTER(
    ALL(fChecklists2),
    fChecklists2[IdChecklist] = Ultimo_Checklist
    )
    )

    RETURN
    KM_Anterior