Find First Negative Value In Column

[Anonymous]

I have a measure that finds the minimum value found in a separate table, in this Example, 504 (x) is the minimum value found in column B (y), but I need it to instead find the first negative value, so in this example 441 (z). How do I create a measure that does so?

Example

[danextian]

Hi @Anonymous ,

The solution will depend on how you want to find the first negative as the data could always be sorted by different columns and may not be in the same order as your source data. Is it by date, descending or ascending? By a column which can be arrange alphabeticaly? By the row number based on the source data? Etc.

[Anonymous]

Is it possible to create a column that sorts the values by date of the first negative value that is found in the source data? So if 441 = 6/4/22, 504 = 6/10/22, and 1008 = 5/4/22, the column's values would be: 6/4/22, 6/10/22, and 5/4/22?