Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I need to replace value null by previous value
I have try something like this
= Table.AddColumn(#"Added Index", "Custom", each Table.TransformColumns(#"Added Index", "Custom.2", each if Text.Contains([Custom.1], "" )
then
Table.SelectRows(Source, each [custom.1] <> "" and [index] = [index]-1)
else
[Custom.1]))
but my syntax is definitly wrong
After check on the forum I have find some sample but apparently not the same usage than my needed.
If some people can help me to this ?
Best regards
Solved! Go to Solution.
From your data sample, it looks like you could simply use the Table.FillDown function.
Table.FillDown(#"Previous Step",{"Custom.1"})
From your data sample, it looks like you could simply use the Table.FillDown function.
Table.FillDown(#"Previous Step",{"Custom.1"})
Bonjour / Hello
Thank to this ronrsnfld. I have arleady used this command but I think that take only the first value who exist, but not.
That solved my problem.
Thank to this 😀
Best regards