Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 "||".
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.