Display last dates values

[dofrancis3]

Hello Colleagues!

Please i need your help about the following:

I have already a mesure witch contain my pourcentage (in the first column) so, i would like a mesure who will display only pourcentage of last date highlight in yellow in the printscreen below:

Note: I don’t need to calculate pourcentage but just display.

Thank for your support.

[v-yohua-msft]

Hi, @dofrancis3 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yongkang Hua

[Dangar332]

hi, @dofrancis3 

try below measure

latest_date=
calculate( 
    [your measure],
    max(table[startdate],
    allexcept(table,table[table[country]])
)

[Dangar332]

hi, @dofrancis3 

not sure but try below code for measure

latest_date=
 maxx(
          filter(
            all(table[country],table[stratdate]),
            table[country]=max(table[country])
          ),
          table[startdate]
 )

now make table visual and drag your country column and percantage measure and  above latest_date measure

[dofrancis3]

It doen't work unfortnatly 

[Daoud_H]

Hi @dofrancis3,

Maybe this will do the trick, try to create a column : 

LastDatePercentage = 
VAR LatestDate = MAX('YourTableName'[Start date])
RETURN
CALCULATE(
    MAX('YourTableName'[LQAS]),
    FILTER(
        'YourTableName',
        'YourTableName'[Start date] = LatestDate
    )
)

[dofrancis3]

Dear @Daoud_H it doen't work note that is a mesure

[dofrancis3]

Hello Guy!

Please support...