Forum Discussion

Creative_tree88's avatar
Creative_tree88
Icon for Helper V rankHelper V
1 year ago
Solved

Lookup latest date, but dealing with multiple values

Hi - I have the attached data.  The data on left represents the source data (shaded yellow), and the data to the right (shaded all blue) represents the desired result using some form of lookup.   I...
Need Help
  • vanessafvg's avatar
    vanessafvg
    1 year ago

     

    Last Valid Weight =
    VAR lastdte =
    CALCULATE (
    MAX ( CustomerWeight[Measure Date] ),
    NOT ( ISBLANK ( CustomerWeight[Weight] ) )
    )
    VAR result =
    CALCULATE (
    MAX ( CustomerWeight[Weight] ),
    CustomerWeight[Measure Date] = lastdte
    )
    RETURN
    IF ( result = 0, "No Height Listed", result )

     

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
1 year ago

you could but it would not longer be a numeric piece of data, it would need to be come  a text column, it could be solved  by using an if statement.   are you wanting it to be text?

Creative_tree88's avatar
Creative_tree88
Icon for Helper V rankHelper V
1 year ago

vanessafvg It could be text, yes.  Would be interested to see the result.