How to compare calumn value with measure value in visual?

[Anonymous]

Hello everyone @Greg_Deckler ,

I am looking for a way to dynamically compare two values in a table.

But the LASTMODIFIED value is a column in my dataset and the LatestResult value is calculated measure using this formula:

LatestResult =

var MaxDate = CALCULATE(MAXX(RESULT,RESULT[LASTMODIFIED]),

ALLEXCEPT(RESULT,[TC_UUID]))

return MaxDate

What I want is to modify the formula above so it doesnt show max date anymore but TRUE or FALSE or 0/1 to show if it is the LatestResult or not.

How can I achieve this? The goal is to later be able to filter out the older results in a PieChart for example, thats why it has do be done dynamically with a measure and not PowerQuery or Calculated Columns.

[Anonymous]

So for specification I need something like this:

But I dont know how to reference the LASTMODIFIED column...

Thanks upfront to everyone.

[Greg_Deckler · Accepted solution]

@Anonymous Should be IF(LatestDate = MAX([LASTMODIFIED],TRUE(),FALSE())

If this is in a table visual.