Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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%.
Solved! Go to Solution.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |