Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Displaying data by latest timestamp

Hi there,   I am building a report to visualize number of patients on each hospital unit. This data is inputted by nursing staff throughout same day. The idea is to create a table that shows last i...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    You can create a visual level filter:

     

    Measure = IF(MAX('Table'[Created]) = CALCULATE(MAX('Table'[Created]),ALLEXCEPT('Table','Table'[Unit])),1,0)

     

     

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

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi parry2k I tried the formula but it's giving a total sum of number of patients on 5C rather than the most recent entry.