Hi Community,
I have a Sales Dashboard where I am calculating Month to Date Sales Target based on No of fullfillment Days that have passed. I am getting correct results for all months except March, June and November. The Sales Target does not change as the number of days change, it stays static.
I have used below DAX Functions:
Monthly_Target_Till_Date = ABS(CALCULATE([Month_WorkingDaysthathavepassed]*(DIVIDE((SUM(Budget_File[Sum_of_Budget])/[Fulfillment_Days]),1))))
When I look at individual figures for June then it seems No.of_Working_Days_LeftInCurrent_Month is not executing properly at backend.
When I change it to other months then MTD Sales Target Till Date gets updated.
Please help me to resolve this issue
Solved! Go to Solution.
This issue has been resolved. I updated the && operator to OR "||".
This issue has been resolved. I updated the && operator to OR "||".
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
105 | |
77 | |
72 | |
48 | |
47 |
User | Count |
---|---|
158 | |
86 | |
80 | |
68 | |
66 |