Use previous data to fill in blanks in table

[REKLP]

I have gaps between my data. 

I'd like to fill them in with the previous data, for example.

I tried using an if statement (shown below), but it doesn't seem to work because there's just no data there.  I don't want to put a zero either.

I also tried putting zero + the calculated measure, but that doesn't work either.

CountOfRowsInTable = 
IF(
    ISBLANK(
        CALCULATE (
            SUM( AppendedTables[Active] ),
            FILTER (
                ALLEXCEPT(AppendedTables, v_infohr_region[ED_REGION], v_infohr_plant[plant]),
                AppendedTables[Year-Month] <= MAX ( AppendedTables[Year-Month] )
            )
        )
    ),
    CALCULATE (
            SUM( AppendedTables[Active] ),FILTER(AppendedTables,0=0)
        ),
    CALCULATE (
            SUM( AppendedTables[Active] ),
            FILTER (
                ALLEXCEPT(AppendedTables, v_infohr_region[ED_REGION], v_infohr_plant[plant]),
                AppendedTables[Year-Month] <= MAX ( AppendedTables[Year-Month] )
            )
    )
)

[AlB]

Hi @REKLP

I ran a quick test and it does seem to work, unless I've misunderstood what you're trying to achieve. I am using a simple measure instead of yours so the issue might be there but the pattern should be fine.

What the code does is actually reenact what you have in the matrix within the measure. If the result for [YourMeasure] is blank in the current row of the matrix, the measure takes all [Year-Month] previous to the current [Year-Month] and finds the last one for which the result of [YourMeasure] is non-blank.       

[REKLP]

@AlB, Do you mind uploading the PBIX so I can take a look please?

[Anonymous]

can fill in null values in PQ relatively easy.  If you upload some data I'll take a look

[REKLP]

@Anonymous, Thank you for the offer, but I'd rather not at this time due to the information in the pbix.

Do you have a sample/link of what you propose?

[Anonymous]

Take a look at the attached PBIX file and step through the applied steps on the right.  There are two ways in there a simpler way and a  little more complex way, but nothing to terrible 🙂

File:

https://1drv.ms/f/s!AoQIGRpzoxRH-kGIakeyIX57LUqW