Forum Discussion
Weekly Target Calculation Dax
Good evening, I'm going to detail as best I can the problem I have with calculation:
I have a table which keeps the monthly sales target capital amount of the executive
In turn, that monthly goal, depending on the week of the month, takes a percentage of the monthly goal to have a weekly goal, for example:
Week1 = 20% of objetivo_mensual
Week2 = 35% of objetivo_mensual
Week3 = 25% of the objetivo_mensual
week4 = 20% of the objetivo_mensual
What I now need is that the amount taken out in each week is redistributed in the number of days you have each week, the drawback I have is that when I use the SLICER of days attached it does not filter me by week, that is, it does not vary the weekly amount of the objective.
On the other hand, I need that amount that was calculated weekly to be distributed among the number of days you have each week, since that calculation is compared with the daily sales to be informed of the missing or surplus amount that there is in the sales, I only have problems with the sales objectives
Second request: Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523