Showing Previous Month /Current Month Values in Future Month values

[Prodosh]

Hi Team,

I have a requirement in which i need to update the Current Month value to Upcoming Month values that are showing null.For Example in the Below Scrrenshot the Sales value in Current month 2018/09 should get updated to 2018/10, 2018/11, 2018/12

Please find the Screenshot Below. Any Help would be appreciated. 🙂

[Greg_Deckler]

So, are you saying that those last 3 values should show the value for 2018/09 (441,600.11) instead of blank?

[Prodosh]

yes

[v-jiascu-msft · Accepted solution]

Hi @Prodosh,

We could use a measure like below. If you need the exact formula, please provide a dummy sample.

Measure 7 =
VAR lastDateHasSales =
    CALCULATE (
        LASTNONBLANK (
            'Calendar'[Date],
            CALCULATE ( SUM ( FactSales[SalesQuantity] ) )
        ),
        ALL ( 'Calendar' )
    )
RETURN
    IF (
        ISBLANK ( SUM ( FactSales[SalesQuantity] ) ),
        CALCULATE (
            SUM ( FactSales[SalesQuantity] ),
            FILTER (
                ALL ( 'Calendar' ),
                YEAR ( 'Calendar'[Date] ) = YEAR ( lastDateHasSales )
                    && MONTH ( 'Calendar'[Date] ) = MONTH ( lastDateHasSales )
            )
        ),
        SUM ( FactSales[SalesQuantity] )
    )

Best Regards,

Dale

[Prodosh]

Hi @v-jiascu-msft

Thanks for your Reply. this logic is working fine.