How to Calculate Month Over Month % change in DAX?

Power BI
1

I have created MOM% DAX measure and used it in a table visual to see % change in sales. How can I make sure it only calculates when current month sales is present?

In my case I don’t want to see MOM% April month in the table. How can I achieve that?

MoM% =

    VAR __PREV_MONTH =
        CALCULATE(
            [Total Sales],
            DATEADD('WalmartSQL repository'[dtme].[Date], -1, MONTH)
        )
    RETURN
        DIVIDE([Total Sales] - __PREV_MONTH, __PREV_MONTH)

Walmart.pbix (156.6 KB)

2

See if it helps
image

PMS = 
VAR Var1 = [Total Sales]
RETURN
    CALCULATE (
        [Total Sales],
        FILTER (
            DATEADD ( 'WalmartSQL repository'[dtme].[Date], -1, MONTH ),
            Var1 <> 0
        )
    )

MoM% = 
VAR Var1 = [Total Sales]
VAR __PREV_MONTH =
    CALCULATE (
        [Total Sales],
        FILTER (
            DATEADD ( 'WalmartSQL repository'[dtme].[Date], -1, MONTH ),
            Var1 <> 0
        )
    )
RETURN
    DIVIDE ( [Total Sales] - __PREV_MONTH, __PREV_MONTH )