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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
markefrody
Post Patron
Post Patron

Value Difference and % Difference Between Consecutive Months

Hi everybody,

 

I'm trying via DAX to get the following:
1. Average Load per Day in a month for similar group.
2. Value difference of the average load per day in a month between 2 consecutive months for similar group.
3.  Percentage difference of the  average load per day in a month between 2 consecutive months for similar group.

I'm having a difficult time in creating it since there are also individual dates in my data set. Aside from that, I need to exclude weekends (Saturday and Sunday) in the calculations. 

Here is a screenshot of the raw data:

markefrody_0-1693292509027.png



What I want the data to look like for Group A wherein it is in a year/month level:

markefrody_1-1693292653505.png

 

Avg Load / Day column = Sum of Loads / Sum of Plan Days
Current vs Previous Month Difference = Current Row "Avg Load / Day" - Previous Row "Avg Load / Day"
% Difference =  Absolute value((Current vs Previous Month Difference /  Previous Row "Avg Load / Day"))*100

Here is the spreadsheet of the raw data:
https://www.dropbox.com/scl/fi/ancdbwdsvn3aehlrbuok0/Data4.xlsx?rlkey=naqgs3c0se2931wg4emsidati&dl=0

Here is the Power BI Desktop wherein raw data is imported:
https://www.dropbox.com/scl/fi/l2dk6lgjxm7p3m4r2hxio/Example.pbix?rlkey=30zlbdiv3210siznebijaafhv&dl...

 

Please note that this calculation needs to be done for similar named groups only in column "Group". So for example, Group A will need to get the difference between 2 consecutive year/month level for Group A only.  So for Group B, get difference between 2 consecutive year/month level for Group B only. Also weekends (Saturday and Sundays) needs to be excluded in the calculation.

Appreciate your kind assistance.

Best regards,
Mark V.

1 REPLY 1
markefrody
Post Patron
Post Patron

Hi. Appreciate your help if any. Thanks.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.