Most Recent Date Rows Display Only

[common763]

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

[AbhinavJoshi · Accepted solution]

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 · Accepted solution]

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.

[AbhinavJoshi · Accepted solution]

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