Forum Discussion
Solved
Looking to restrict Total column calculation over specific months data only
Hi Team, I am trying to calculate simple %variance formula based on (Actuals- Fcst)/(Fcst) for my data. At monthly level, this is working fine, however for some months we do not have actuals but...
apkmnp , Try like
Measure =
var _for = sumx(filter(Values(Table[Month Year]), not(isblank([Actual])) ), [Target])
return
divide([Actual] -_for,_For)
amitchandak
Super User
Super Userapkmnp , Try like
Measure =
var _for = sumx(filter(Values(Table[Month Year]), not(isblank([Actual])) ), [Target])
return
divide([Actual] -_for,_For)