need to get column with the value of project with the latest date only

[Anonymous]

Hi team,

as shown in the table I have the column Project name, Data Date date, and the E.V

the E.V is a cumulative value so I would like to create a measure or add a new column to have the only value of the latest Data Date and the rest of the dates gives Null(blank).

Can I achieve something that I am looking for?

Please help

Thanks in advance,

[Anonymous]

Does dose anyone have an idea ??

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Please try the measure.

Measure = IF(MAX('Table'[Date]) = CALCULATE(MAX('Table'[Date]),ALLSELECTED(),VALUES('Table'[Project name])),SUM('Table'[E.V]) )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Anonymous 

You can add  column as follows, change the Tablename as per yours

Latest Date = IF(   MAX(Tablename[Data Date]) = Tablename[Data Date] , Tablename[Data Date] )

[Anonymous]

thank you very much for your attention, but it does not consider the filter on the project name, I would like to take but the value considers the max date for each project only not for the whole dates so I need to but the project name as the factor of max criteria