Forum Discussion
Helper IIIMost 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 easily do this if I do not include the version as I can display most recent date. The problem arises when I want to include the version number. It is free text so I have a PROGID and Program to align it with but will show everything (every version and associated date). Is there a column or measure I can write to only show Program, and Most recent date w the associated version? So instead of all three ABC versions displayed below, I would just display version C with 3/1/2022.
| Program | PROGID | Version | Date |
| ABC | 1 | a | 1/1/2020 |
| ABC | 1 | b | 2/1/2021 |
| ABC | 1 | c | 3/1/2022 |
| EFG | 2 | a | 1/1/2020 |
| EFG | 2 | b | 2/1/2021 |
| EFG | 2 | c | 3/1/2022 |
| HIJ | 3 | a | 1/1/2020 |
| HIJ | 3 | b | 2/1/2021 |
| HIJ | 3 | c | 3/1/2022 |
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/matrixHi,
Please find attached the PBI file.
Hope this helps.
4 Replies
AbhinavJoshiResponsive Resident
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- Ashish_Mathur
Super User
Hi,
Please find attached the PBI file.
Hope this helps.
- common763
Thanks. Disregard other message. Got it to work. I accepted this as a solution but dont see it anymore. Not sure if it registered. Thanks again.
- Ashish_Mathur
You are welcome.