Forum Discussion

jseballo's avatar
jseballo
Frequent Visitor
6 years ago
Solved

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 increa...
Need Help
jeroenterheerdt's avatar
jeroenterheerdt
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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?

jseballo's avatar
jseballo
Frequent Visitor
6 years ago

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?  

  • jeroenterheerdt's avatar
    jeroenterheerdt
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    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