Forum Discussion
Solved
Filling Data Gaps, Conditionally
Hi, I have a table that looks like the one below. One of the data columns has some blanks that I would like to fill. How can I fill downward, but only when the identifier (first column) of the '...
A Dax solution .
Would be a new calculated column:
NewD = IF ( Table1[D] = BLANK (), CALCULATE ( LASTNONBLANK ( Table1[D], Table1[D] ), FILTER ( ALLEXCEPT ( Table1, Table1[A ] ), Table1[B] <= EARLIER ( Table1[B] ) ) ), Table1[D] )The Columns Are A,B,C,D in the order of your sample data..
A Dax solution .
Would be a new calculated column:
NewD =
IF (
Table1[D] = BLANK (),
CALCULATE (
LASTNONBLANK ( Table1[D], Table1[D] ),
FILTER ( ALLEXCEPT ( Table1, Table1[A ] ), Table1[B] <= EARLIER ( Table1[B] ) )
),
Table1[D]
)
The Columns Are A,B,C,D in the order of your sample data..
Thanks Vvelarde.
When I run this formula I am almost getting the solution: In the 5th row from the bottom, we should have a value of 6 in the New D column, but we are getting a null. Why is this? Thanks.