Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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%.

 

 

 

 Power BI Capture 2.PNGPowerBI Capture.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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])

View solution in original post

3 REPLIES 3
v-cherch-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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])

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.