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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous do you have two records for the same timestamp on 5c? Not sure if I understood your question. Maybe share sample data where you see this issue to further look into it.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi parry2k 

 

I have attached the data - I am trying to display the latest census and latest projected census by unit

 

For 8C - I would like to display current census inputted 9 minutes ago

and 5C it would be the current census inputted yesterday at 5:02 PM

 

Beyond the table, would it be possible to use the measure as a report level filter? I appreciate your input! Thanks so much!