Forum Discussion
Weekly Target Calculation Dax
Good evening, the model does have a calendar table, but for the calculation of the week as the company takes it is the one I attached above, I don't know if it is possible to attach a pbix file with a model summarized in only the tables that intervene in the calculations, I was trying with some formulas to be able to calculate the percentage and use it in the table but I can't get it to filter inside the table I don't know If you could help me with that calculation, the measurement I'm using is as follows
Weekly Goal =
VAR MonthlyTarget = SUM(tabla_objetivo[MonthlyTarget])
VAR TargetWeek1 = MonthlyTarget * 0.20
VAR TargetWeek2 = TargetWeek1 + (MonthlyTarget * 0.35)
VAR TargetWeek3 = TargetWeek2 + (MonthlyTarget * 0.25)
VAR TargetWeek4 = TargetWeek3 + (MonthlyTarget * 0.20)
RETURN
SWITCH(TRUE(),
ISINSCOPE(tabla_objetivo[Vendor]),
SWITCH(TRUE(),
VALUES('Calendar'[Week]) = 1,TargetWeek1,
VALUES('Calendar'[Week]) = 2, WeekGoal2,
VALUES('Calendar'[Week]) = 3, WeekGoal3,
VALUES('Calendar'[Week]) = 4, WeekGoal4
),
MonthlyGoal
)
But moving the slicer from days to days sets the monthly target
I don't know if it is possible to attach a pbix file
Please follow the instructions in the link I posted (twice).