Forum Discussion
Creative_tree88
Helper V
Helper VLookup 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...
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 )
Creative_tree88Helper V
Helper Vvanessafvg Is there a way of introducing text to each measure, to add to the table in the event of there being no data to return. For example 'No Height Data' where there is nothing. Many thanks again.
vanessafvg
Community Champion
Community Championyou 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
vanessafvg It could be text, yes. Would be interested to see the result.