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

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
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