Forum Discussion
Convert excel formula to DAX
I really really need your help converting this excel formula to Dax using columns only. 1. (Weight * PreviousMonth of Actual Volume) (1-Weight) * SmoothedForecast := These are common formulas 2. ...
Anonymous i think you need a rescusion, but it's sadly that dax can not do it well. measuse can not reference itself.
probably you need to find another way to solve this.
Hi
SmoothedForecast:=if(isempty(previousmonth(dates[date],-1,month)),blank(),if([Previousmonth],[weight]*[auctualAmount]+(1-[weight])*[Previousmonth], [auctualAmount]))
wdx223_Daniel
The problems are I can't call "SmoothedForecast when the next nested if for blank forcasted Smoothed is blank. that should be the actual as is result.
wdx223_Daniel
Community Champion
Community ChampionAnonymous i think you need a rescusion, but it's sadly that dax can not do it well. measuse can not reference itself.
probably you need to find another way to solve this.
Yes I agree with you 😞 it can't be called columns result on its column..
This is sad 😞