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

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