Forum Discussion
Latest Value
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?
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
Thank 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 youSorry, ı 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?
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?