Measure Sale change

[Atinder]

Hello, 

I wanted to measure my monthly sales change by product.

Starting month is January. Like in Feb is my sales dropped or increased vs Jan sales.  How Can i do this powerbi? I can do in the excel. 

[v-zhangti · Accepted solution]

Hi, @Atinder 

You can try the following methods.

Sample data:

Measure:

PrevSales = 
VAR PrevDate =
    MAXX (
        FILTER (
            ALL ( 'Table'[Date], 'Table'[Item_No] ),
            'Table'[Date] < SELECTEDVALUE ( 'Table'[Date] )
                && [Item_No] = SELECTEDVALUE ( 'Table'[Item_No])
        ),
        'Table'[Date]
    )
VAR PrevSales =
    CALCULATE (
        SUM ( 'Table'[Sales] ),
        FILTER (
            ALL ( 'Table' ),
            [Date] = PrevDate
                && [Item_No] = SELECTEDVALUE ( 'Table'[Item_No])
        )
    )
RETURN
    PrevSales

Difference = IF([PrevSales]<>BLANK(),SUM('Table'[Sales])-[PrevSales])

Change = DIVIDE([Difference],[PrevSales])

Measure is placed in the matrix view as shown in the figure.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.