Forum Discussion
Helper IIFilter a table visual by latest date
Hello, I've tried to replicate the datasets, you can use a measure to calulate the latest date for the ID. Navigate to modelling tab, and then New Measure. In the formula bar enter this formula
Latest Visit = CALCULATE(MAX('Sheet1'[Date]), ALLEXCEPT('Sheet1', 'Sheet1'[Seq])). Change the Sheet1 name with your table name. Then you can bring this measure to your table/matrixI hope it helps!
Responsive ResidentHi JoeCrozier. Are you looking to filter by date let's say after May 31, 2023, or you are looking to sort the results by earliest date. If sorting helps you, go to the the Data View, navigate to the table, and in the Column Tools, select sort by column "Ascending or Descending". Hope it hepls
Helper IIAbhinavJoshi thank you for replying!
So our intent with this page is really just to check that for each subject, they do or do not have an upcoming planned visit date. So as you can see in the above photo, that subject outlined in the middle is shown in three rows, his/her next 3 visits. Well, I dont need all three of his visits, a row for each. I just need ONE row with their next visit. So i'd love to filter to one row for that '158' patient. Does my phrasing make sense?
- AbhinavJoshi
Hello, I've tried to replicate the datasets, you can use a measure to calulate the latest date for the ID. Navigate to modelling tab, and then New Measure. In the formula bar enter this formula
Latest Visit = CALCULATE(MAX('Sheet1'[Date]), ALLEXCEPT('Sheet1', 'Sheet1'[Seq])). Change the Sheet1 name with your table name. Then you can bring this measure to your table/matrixI hope it helps!