Forum Discussion

Atinder's avatar
Atinder
Helper III
4 years ago
Solved

Measure Sale change

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. 

 

 

Data Protection
Dataflow
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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.

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    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.