Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Typically you do that in Power Query with something like "Fill".

ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

@Hi Greg_Deckler,

 

Thank for your answer,

 

However the dataset doesn't have this row. just my date table.

 

I should use this function "Fill" when the value is blank, right ?

 

Thank you,

 

Ricardo

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi ricardocamargos

     

    One approach might be to create a Calculated Table with Missing Dates and Values

     

    From the Modelling Tab>>>NEW TABLE

     

    New Table =
ADDCOLUMNS (
    GENERATESERIES ( MIN ( TableName[Date] ), MAX ( TableName[Date] ) ),
    "Values",
    VAR Maxdate =
        CALCULATE (
            MAX ( TableName[Date] ),
            FILTER ( TableName, TableName[Date] <= EARLIER ( [Value] ) )
        )
    RETURN
        CALCULATE ( SUM ( TableName[Value] ), TableName[Date] = Maxdate )
)