Forum Discussion

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 )
)