Solved: Replacevalue with preceding row value if null

Pellegrino · ‎07-17-2021

I have a column that is either null or has a value.

What I want is for 'm' to scan the entire column and replace null values with the preceding value.

My Code is this:

= Table.ReplaceValue(#"Added Custom3",each
[MyIndex],each if [MyIndex] = null then
(RawData1[MyIndex]{[Index]-1}) else [MyIndex],Replacer.ReplaceValue,{"MyIndex"} )

But it's not updating, and I don't know why. I'm assuming 'm' updates rows sequentially.

watkinnc · ‎07-17-2021

In the formula bar, type:

= Table.FillDown(#"Added Custom3", {"MyIndex"})

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

View solution in original post

watkinnc · ‎07-17-2021

In the formula bar, type:

= Table.FillDown(#"Added Custom3", {"MyIndex"})

--Nate

I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

Replacevalue with preceding row value if null

Helpful resources

Microsoft Build is May 24-26. Have you registered yet?

Charticulator Design Challenge

What difference can a User Group make for you?

Check it out!