Inventory Level for every day, also dates with no row entry

Wonter,

Try this measure. It requires a date table with a 1:* relationship with the fact table HistoricalInventory. In the visual, use Dates[Date].

Minimum Stock = 
VAR vCurrentDate =
    MIN ( Dates[Date] )
VAR vPreviousDate =
    CALCULATE (
        MAX ( HistoricalInventory[history_date] ),
        Dates[Date] < vCurrentDate
    )
VAR vFilterPreviousDate =
    TREATAS ( { vPreviousDate }, Dates[Date] )
VAR vStockPreviousDate =
    CALCULATE ( MAX ( HistoricalInventory[stock] ), vFilterPreviousDate )
VAR vResult =
    IF (
        // if Dates[Date] does not exist in HistoricalInventory, use the last value
        ISEMPTY ( HistoricalInventory ),
        vStockPreviousDate,
        MAX ( HistoricalInventory[stock] )
    )
RETURN
    vResult

Wonter,

Thanks for the link. I found the issue. The variable vPreviousDate in the measure needs to use date, not historical_date (the relationship with DateTable is based on date, not historical_date.

VAR vPreviousDate =
    CALCULATE (
        MAX ( kiosks_historicalkioskarticle[date] ),
        DateTable[Date] < vCurrentDate
    )