Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculating % Change between selected periods

Does anyone know how to calculate the change between selected periods. I want to be able to compare one 4 week period to another.

 

I want to show the % change between the sum of (9/22, 9/29, 10/06, and 10/13) to the sum of (5/26, 6/02, 6/09, and 6/16).

 

The % should be somewhere around 13.6%.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks! I ended up doing something pretty similar to that.  Mine looked like this:

     

    Total Sales Period 1 = CALCULATE(SUM(Table1[Total Sales]), DATESINPERIOD(Table1[Date].[Date],MAX(Table1[Date]),-22,DAY) )

     

    Total Sales Period 2 = CALCULATE(SUM(Table1[Total Sales]), DATESINPERIOD(Table1[Date].[Date],MIN(Table1[Date]),22,DAY) )

     

    Sales Difference = [Total Sales Period 2] - [Total Sales Period 1]

     

    % Change = DIVIDE([Sales Difference], [Total Sales Period 2])

3 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous

     

    You may try to create a measure like below:

    FirstPeriod =
CALCULATE (
    SUM ( Table1[Total Sales] ),
    FILTER (
        Table1,
        Table1[Date]
            IN {
                VALUE ( "9/22/18" ),
                VALUE ( "9/29/18" ),
                VALUE ( "10/06/18" ),
                VALUE ( "10/13/18" )
            }
    )
)
    SecondPeriod=CALCULATE(SUM(Table1[Total Sales]),FILTER(Table1,Table1[Date] in { VALUE("5/26/18"), VALUE("6/02/18"),VALUE("6/09/18"), VALUE("6/16/18")}))
    % =
DIVIDE ( [SecondPeriod] - [ FirstPeriod], [ FirstPeriod] )

    Regards,

    Cherie

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks! I ended up doing something pretty similar to that.  Mine looked like this:

       

      Total Sales Period 1 = CALCULATE(SUM(Table1[Total Sales]), DATESINPERIOD(Table1[Date].[Date],MAX(Table1[Date]),-22,DAY) )

       

      Total Sales Period 2 = CALCULATE(SUM(Table1[Total Sales]), DATESINPERIOD(Table1[Date].[Date],MIN(Table1[Date]),22,DAY) )

       

      Sales Difference = [Total Sales Period 2] - [Total Sales Period 1]

       

      % Change = DIVIDE([Sales Difference], [Total Sales Period 2])

      • v-cherch-msft's avatar
        v-cherch-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi Anonymous

         

        Glad to hear it has been solved, please accept your answer as solution, that way, other community members will easily find the solution when they get same issue.

         

        Regards,

        Cherie