Forum Discussion

JoeCrozier's avatar
JoeCrozier
Icon for Helper II rankHelper II
3 years ago
Solved

Filter a table visual by latest date

I have a question very similar to this one: https://community.fabric.microsoft.com/t5/Desktop/Power-BI-table-visual-to-get-only-latest-date-value/m-p/223073   I have a table visual that looks like ...
Need Help
  • AbhinavJoshi's avatar
    AbhinavJoshi
    3 years ago

    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/matrix 

    I hope it helps! 

JoeCrozier's avatar
JoeCrozier
Icon for Helper II rankHelper II
3 years ago

AbhinavJoshi 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's avatar
AbhinavJoshi
Icon for Responsive Resident rankResponsive Resident
3 years ago

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/matrix 

I hope it helps!