Measure Totals, The Final Word
With apologies to Theodor Geisel...
Measure totals have you perturbed? Fear not! It's Measure Totals, The Final Word,
These measures work with matrices, They work with tables, They wo...
Hi,
I have a calculated field Goal which is not giving the sum correct.
How do I make it working?
Goal =
/* convert(max(rev_tasks[Goal_Months]),INTEGER)*/
var vgoal=max(rev_tasks[Goal_Months])
Return
SWITCH(TRUE(),
vgoal=BLANK(), BLANK(),
vgoal="1",(1+MAX(rev_tasks[Goal_Perc]))*SUM(C_AR[Revenue]),
vgoal="2", CALCULATE(SUM(C_AR[Revenue]),DATESINPERIOD('dates'[Date],MAX('dates'[Date]),-2,MONTH))*(1+MAX(rev_tasks[Goal_Perc])),
vgoal="3", CALCULATE(SUM(C_AR[Revenue]),DATESINPERIOD('dates'[Date],MAX('dates'[Date]),-3,MONTH))*(1+MAX(rev_tasks[Goal_Perc])),
vgoal="AR",[AR]
)