Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Helper V
4 years ago
Solved

look up or filter data

Hello,   i have a table with several equipments. i want to get the first and the last value of the day for one equipment in the following table the green and orange value. but i'm struggli...
Need Help
  • GeekAlfPro's avatar
    GeekAlfPro
    4 years ago

    I finally manage to get what i want

    by using firstnonblankvalue and lastnonblankvalue.

     

    thanks !

tackytechtom's avatar
tackytechtom
Most Valuable Professional
4 years ago

Hi GeekAlfPro ,

 

I have a solution here:


And these are the measure in DAX:

TomsMaxMeasure = 
CALCULATE ( 
    MAX ( Table5[value]  ),
    ALLEXCEPT ( table5, Table5[id_equipment], Table5[timestamp] )
)
TomsMinMeasure = 
CALCULATE ( 
    MIN ( Table5[value]  ),
    ALLEXCEPT ( table5, Table5[id_equipment], Table5[timestamp] )
)


Does this solve your issue? 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 

GeekAlfPro's avatar
GeekAlfPro
Helper V
4 years ago

Hello tackytechtom ,

 

thanks for your response.

unfortunately, et because i wasn't explicite enough, it not exactly the solution.

i have outliers, that's why i want to get the first data of the day and the last one

 

your formulas give me the min and max of the values.

i want the values associated with the min / max of timestamp.

i hope i'm clear enough

  • GeekAlfPro's avatar
    GeekAlfPro
    Helper V
    4 years ago

    I finally manage to get what i want

    by using firstnonblankvalue and lastnonblankvalue.

     

    thanks !