Forum Discussion
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!
| Probable Root Cause | Compl Post Date |
| DC needs research | 7/14/2020 |
| DC needs research | 7/14/2020 |
| Late supplier delivery | 7/13/2020 |
| DC Lead time > planning time | 7/13/2020 |
| DC Lead time > planning time | 7/13/2020 |
| Late supplier delivery | 7/13/2020 |
| Late supplier delivery | 7/13/2020 |
| DC Lead time > planning time | 7/13/2020 |
| On Time | 7/13/2020 |
| On Time | 7/13/2020 |
| On Time | 7/13/2020 |
| On Time | 7/13/2020 |
I think what you are looking for is in this list: https://www.dutchdatadude.com/ultimate-time-based-calculations-cheat-sheet-for-dax-power-bi-including-week-based-calculations/
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
6 Replies
I think what you are looking for is in this list: https://www.dutchdatadude.com/ultimate-time-based-calculations-cheat-sheet-for-dax-power-bi-including-week-based-calculations/
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?
