The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to Solution.
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-includin...
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
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
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-includin...
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
107 | |
96 | |
53 | |
47 | |
47 |