Forum Discussion

SDream7's avatar
SDream7
Icon for Helper I rankHelper I
7 years ago

Select Most Recent Client Record Given Date Values Selected

Hello everyone,   I've been having trouble finding a solution for this problem, having not been able to replicate solutions posted to similar problems featured on the forums.   In the link below,...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi SDream7

I want the Client Table, based on both the Admission and Discharge Dates selected, to show the latest record for each Client ID

this can be done by creating a measure instead of a calculated column  for calculated columns can't change with the slicer.

 

"the Latest Record calculated column should be capable of being used as a slicer as well"

To make the Latest Record change based on the slicer, it should be a measure, so it can't be used as a slicer.

 

I believe the requirements from your statements can be achieved except creating the Latest Record as a calculated column.  

 

Best Regards

maggie

 

  • SDream7's avatar
    SDream7
    Icon for Helper I rankHelper I
    7 years ago

    Thank you for your response. How might I go about creating what I want into measures?

    • SDream7's avatar
      SDream7
      Icon for Helper I rankHelper I
      7 years ago
      Bump