Complete whit the last nonblank value (measure)

[SilvioLunaPBI]

Hello all,

I need to be able to do this and I don't know how, fill in blanks with the last value that is not blank. 

example file: https://drive.google.com/file/d/1LnFY7i6GLjyTI3uPs_H7PxWNK0PKoLL2/view?usp=sharing

Regards,

[SilvioLunaPBI]

Hello, @wdx223_Daniel  First of all, thank you!

The fields ending in "A" are the ones calculated with the code you made. But when doing the calculation grouped by country, it does not use the last values of each customer. Is it possible to do so?

Tks!

[SilvioLunaPBI]

Tks a lot!

[wdx223_Daniel · Accepted solution]

create a date table and mark it as date table