Forum Discussion
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 to the table. Can you help me ?I want to obtain newest table like that
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?
7 Replies
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 0Thank you, it works. But if ı have one more date column, how can ı approach to obtain the same result with a date?
I don't understand, please explain again
Share sample pbix file to help you
and what result are you expecting, also show
