Latest Value

[knightwatch]

Hi everyone, ı have a data table, and ı want to make a new table that has the latest column value. As you can see, some types have different least values again, and ı want to add these newest values to the table. Can you help me ?I want to obtain newest table like that

[Ahmedx · Accepted solution]

pls see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiA_GW1l9-SaNFJ2x?e=1dheto

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiA5oxk5XTqg0mYbU?e=tPo23M

if
List.Range(
from[Type]&{"oooooooooooooooo"},[Index]+1,1){0} <> [Type] then [Value] else 0

[Ahmedx]

and what result are you expecting, also show

[Ahmedx · Accepted solution]

pls see my video
https://1drv.ms/v/s!AiUZ0Ws7G26RiA_GW1l9-SaNFJ2x?e=1dheto

Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26RiA5oxk5XTqg0mYbU?e=tPo23M

if
List.Range(
from[Type]&{"oooooooooooooooo"},[Index]+1,1){0} <> [Type] then [Value] else 0

[knightwatch]

Thank you, it works. But if ı have one more date column, how can ı approach to obtain the same result with a date?

[Ahmedx]

I don't understand, please explain again
Share sample pbix file to help you

[knightwatch]

Sorry, ı could not share the pbix, but let me explain more clearly. I want to obtain the below table. It is similar, but there is one more date column. Can you help me?

[Ahmedx · Accepted solution]

in this example, the DATE column does not play any role here, so my solution is suitable for this scenario.
but you need to keep the date column.
but I'm afraid that you actually have a different scenario.

can you create an example file which reproduces your issue?

[knightwatch]

I handled it yesterday, thanks to your explanation. I used your way with some extra arrangements. Thank you so much; take care 🙂