Forum Discussion
Solved
Latest Value
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 ...
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=tPo23Mif List.Range( from[Type]&{"oooooooooooooooo"},[Index]+1,1){0} <> [Type] then [Value] else 0in 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?
and what result are you expecting, also show