Get specific date value from Matrix Table based on a condition

[marqueles]

Hi All,

How can i get de first "Payment Date" where "Balance" is negative? in this example the value will be "Viernes 07 de Enero 2022".

Some remarks:

- Amount, is a currency field and comes from the datasource

- Amount Acum, is a measure created with running total function

- Balance, is a measure created with (Initial Balance - Amount Acum)

Thanks in advanced

[v-janeyg-msft · Accepted solution]

Hi, @marqueles 

You can create a measure then use it in conditional formatting. I create a simple sample.

Like this:

Measure =
VAR a =
    MINX ( FILTER ( ALL ( 'Table' ), [Balance] < 0 ), [Payment] )
RETURN
    IF ( SELECTEDVALUE ( 'Table'[Payment] ) = a, "Red" )

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[lbendlin]

This can be done with either measures or calculated columns. Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.