Return Last Value for each Attribute by Another Column Value

cbruhn42 , I think we need to have a date or index column to find data less than this, but you can try like

New column = maxx(filter(Table, [Attribute] = earlier([Attribute])  && [Tank Condition] = "No") , [Value])

or

New column = if([Tank Condition] = ""Yes"  , maxx(filter(Table, [Attribute] = earlier([Attribute])  && [Tank Condition] =

"No") , [Value]) , blank())

refer

Power BI DAX- Earlier, I should have known Earlier: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s&list=PLPaNVDMhUXGYU97pdqwoaociLdwyDRn39&index=1

Forgot to add that I do have a date column.  It is the date/time the tank is conditioned.  Basically when the 'Tank Conditioned' column goes from No to Yes it uses this date column to determine that.

Hi cbruhn42 ,

Please crate a calculate column like:

Last Value = 
VAR CurrentOrder = 'Table'[JFProductionOrder]
VAR CurrentAttribute = 'Table'[Attribute]
VAR Dt = 'Table'[Turbidity DT]
RETURN
IF(
    'Table'[Tank Conditioned] = "No",
    CALCULATE(
        LASTNONBLANK('Table'[Value],1),
        FILTER(
            ALL('Table'),
            'Table'[JFProductionOrder] = CurrentOrder &&
            'Table'[Attribute] = CurrentAttribute &&
            'Table'[Turbidity DT] < Dt &&
            'Table'[Tank Conditioned] <> "Yes"
        )
    )
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

OK, I used a combination of solutions here to get it to work half the time.

This works for when there is a production order that goes from Tank Conditioned = No to Yes.  However, I can't figure out yet how to return the last values for brands that never go from No to Yes.

HEre is what I have so far.