Forum Discussion
jseballo
6 years agoFrequent 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 increa...
- 6 years ago
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/
- 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
jeroenterheerdt
6 years agoMicrosoft Employee
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/