Forum Discussion
Get specific date value from Matrix Table based on a condition
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
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
2 Replies
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.
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
