How to create a Measure that fills the empty cells with the previous value

[veronika_prexl]

I need to compare Column A with Column B.

I want to fill the empty cells with the previous value.

Date               A               B

1.1.              1021          913

2.1.                                  1201

3.1.              1381

4.1.              1669         1525

Date               A               B

1.1.              1021          913

2.1.              1021        1201

3.1.              1381        1201

4.1.              1669         1525

Thank you!

Regards!

Veronika

[harshnathani]

Hi @veronika_prexl ,

You can use the fill down feature in Power Query.

https://www.youtube.com/watch?v=vQIDJVkFW8o

https://www.youtube.com/watch?v=xRDRwnfv1uE

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[az38]

Hi @veronika_prexl 

you need to create 2 new measures

Anew = 
var _prevDate = CALCULATE(MAX('Table'[Date]);FILTER(ALL('Table');'Table'[Date]<SELECTEDVALUE('Table'[Date])&& NOT(ISBLANK('Table'[A]))))

RETURN

IF(ISBLANK(SELECTEDVALUE('Table'[A]));LOOKUPVALUE('Table'[A];'Table'[Date];_prevDate);SELECTEDVALUE('Table'[A]))

and the same for B

Bnew = 
var _prevDate = CALCULATE(MAX('Table'[Date]);FILTER(ALL('Table');'Table'[Date]<SELECTEDVALUE('Table'[Date])&& NOT(ISBLANK('Table'[B]))))

RETURN

IF(ISBLANK(SELECTEDVALUE('Table'[B]));LOOKUPVALUE('Table'[B];'Table'[Date];_prevDate);SELECTEDVALUE('Table'[B]))

do not hesitate to give a kudo to useful posts and mark solutions as solution