Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Latest reading formula

Hi,  Can someone help me with a calculated column and a dax formula, both would have been nice. I want only the latest reading of every ID if the the tempratur is 5 or above give me true, if not g...
Need Help
Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

 

Samall adjustment to a Measure

Measure = 
VAR __tbl = ADDCOLUMNS( 
    VALUES( 'YourTable'[Id] ),
    "mDate", CALCULATE( 
        MAX('YourTable'[Timestamp] ), 
        ALLEXCEPT( YourTable, YourTable[Id] )
    )
)
RETURN 
CALCULATE(
    MAX( 'YourTable'[Temoratur] ),
    KEEPFILTERS( 
        TREATAS( __tbl, 'YourTable'[Id], 'YourTable'[Timestamp] ) 
    )
) >= 5

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi again Mariusz 

Thanx alot for all help this looks better  I will test this out very soon. I am drillingthrough from one page to the next. So when I am on the next page I want this value to be visualise this in a kpi card in my report, if the value is 5 or above give me green light, if 5 or below give me red. How can I visualise this in a best possible way?

Can I use the adcanve card, or any help would be very nice. I am open for any solution and visualtiation. Giving you a screenshot with a example white circle. 


  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

    Are you looking for measure that you can use for conditonal formating or the visual?

    Thanks 
    Mariusz

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Mariusz 

      you have given me a formula for the tempratur and latest reading. But I want to visualse diplay this as green or red light. 

      As a kpi trafficlight but not in a table, just a card. If the tempratur is 5 or above give me green light, if the value is 5 or less give med red. Have you understood? Maybe you have some suggestion of how to visualise this in a best way


      Thanx alot in advance