Forum Discussion
Help With Month to Month Delta
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
Community SupportHi 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?
- jeroenterheerdt
Microsoft Employee
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?
