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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jseballo
Frequent Visitor

Help With Month to Month Delta

Hello All, 

I am wanting to compare the percentage difference between prior months in the year against columns.  Below is my data set as an example.  I would like to understand if column A is increasing or descreasing by area each month.  I would like to present thi informaton in a column chart with postive and negative changes show here. Thanks!Capture.JPG

 

Probable Root CauseCompl Post Date
DC needs research7/14/2020
DC needs research7/14/2020
Late supplier delivery7/13/2020
DC Lead time > planning time7/13/2020
DC Lead time > planning time7/13/2020
Late supplier delivery7/13/2020
Late supplier delivery7/13/2020
DC Lead time > planning time7/13/2020
On Time7/13/2020
On Time7/13/2020
On Time7/13/2020
On Time7/13/2020

 

 

 

2 ACCEPTED SOLUTIONS
jeroenterheerdt
Microsoft Employee
Microsoft Employee

so, you could do something like:

 

IF(MONTH ( Table1[Create Date] ) = MONTH ( TODAY () ), do_something_for_current_month, do_something_for_other_months)

 Let me know if this helps and please mark as solution if I was able to help you

View solution in original post

6 REPLIES 6
v-juanli-msft
Community Support
Community Support

Hi @jseballo 

The article provided by jeroenterheerdt is so helpful.

If your problem still has other concerns, please let us know.

 

Best Regards

Maggie

This was very helpful.  I was able to generate the percentage difference from month to month. One issue that came up is when comparing the existing month, the variance is high because the volume isn't there.  Any tips on how to filter out the current month? 

well, couldn't you just wrap it in an IF statement and return a default value when the volume of this month is not high enough?

The challenge with looking at values is that the values can be irracted.  I am trying to wrap up in an if statement that doesn't do the calculation if the month isn't complete although I am struggling with the logic.  Any suggestions on how this can be acheived with date functions?  

so, you could do something like:

 

IF(MONTH ( Table1[Create Date] ) = MONTH ( TODAY () ), do_something_for_current_month, do_something_for_other_months)

 Let me know if this helps and please mark as solution if I was able to help you

jeroenterheerdt
Microsoft Employee
Microsoft Employee

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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