Forum Discussion

cbruhn42's avatar
cbruhn42
Icon for Helper III rankHelper III
3 years ago

Return Last Value for each Attribute by Another Column Value

  I have a table of measurements above.  I want to return the last measurement Value right before the Tank Conditioned column changes to Yes.  The highlighted values of 1008 for ASBC and 3.9 f...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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

  • cbruhn42's avatar
    cbruhn42
    Icon for Helper III rankHelper III
    3 years ago

    Definately need a date here I think to get this to work right.  Here is a snapshot of the table with the dates I have available.  The other piece I forgot to mention is that there are multiple production orders this occurs on in the data set.  So the values returned are specific to that production order that starts with MR.

     
     
     
     
     

     

  • cbruhn42's avatar
    cbruhn42
    Icon for Helper III rankHelper III
    3 years ago

    amitchandak, do you have another idea now that I submitted the additional information regarding date column?