Forum Discussion

Johan's avatar
Johan
Advocate II
7 years ago
Solved

Missing dates in fact table

Hi,   I've got these 2 tables:   calendar datekey 01-01-2019 02-01-2019 03-01-2019   fact datekey        stock 01-01-2019  50 03-01-2019   70   Report needs to be: Stock levels: date...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Johan 

     

    Hi,

     

    Try this MEASURE

     

    Measure =
CALCULATE (
    SUM ( 'fact'[stock] ),
    LASTNONBLANK (
        FILTER (
            ALLSELECTED ( 'Calendar'[Datekey] ),
            'Calendar'[datekey] <= SELECTEDVALUE ( 'Calendar'[datekey] )
        ),
        CALCULATE ( SUM ( 'fact'[stock] ) )
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Johan 

 

Hi,

 

Try this MEASURE

 

Measure =
CALCULATE (
    SUM ( 'fact'[stock] ),
    LASTNONBLANK (
        FILTER (
            ALLSELECTED ( 'Calendar'[Datekey] ),
            'Calendar'[datekey] <= SELECTEDVALUE ( 'Calendar'[datekey] )
        ),
        CALCULATE ( SUM ( 'fact'[stock] ) )
    )
)