Forum Discussion

common763's avatar
common763
Helper III
3 years ago
Solved

Most Recent Date Rows Display Only

I have a dataset similar to the below.  All I want to do is create a data table that will only display the Program, Version and Date.  The end-user only wants to see most recent version.  I can easil...
Need Help
Show and Tell
  • AbhinavJoshi's avatar
    AbhinavJoshi
    3 years ago

    Hello, you can use a measure to calulate the latest date for the Version. Navigate to modelling tab, and then New Measure. In the formula bar enter this formula 

    Latest Date = CALCULATE(MAX('Sheet1'[Date]), ALLEXCEPT('Sheet1', 'Sheet1'[Version])). Change the Sheet1 name with your table name. Then you can bring this measure to your table/matrix