How to create calcuclated column and put it on legend

[selected_]

I wanna display the latest rating given to an employee. In my data, I have columns 'rating' and '' in the 'doc' table, and a ''. I want to return the latest record rating giv en o an employee based only if the termination date is greater than the  and wanna exclude old given rating.

the table data look like this:

the result should look like this:

how should I do ?

[Ashish_Mathur]

Hi,

PBI file attached.

Hope this helps.

[ryan_mayu]

could you pls provide some sample data?

[selected_]

Here please https://easyupload.io/r09pei

[ryan_mayu]

@selected_ 

you can do this in PQ

pls see the attachment below

[selected_]

Thanks but if i gonna show it as table view why it does show dublicate values once I add more column for example terminationdate? how can I fix it ? because I think then the logic stop work like it gonna show latest reviewEndDate but that are earlier than terminationDate but also not older than the previous years reviewEndDate.

[ryan_mayu]

i think it's because some people rated twic on the same day. 

Since you only have the date value, it return different rating since both are on the max date.

[selected_]

yes but that's a particular emplpyee, my issue is that it does so with all regardless if some people rated twic on the same day

[ryan_mayu]

how can we deal with that scenario? Remove those ratings?