Convert excel formula to DAX

[Anonymous]

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. If 1/1/2019 is no previous month leave it blank
3. If date is on 2/1/2019 the value should be the 1/1/2019 as is.
4. So on my number 1 senario will perform the formulas for entire row

@wdx223_Daniel  apologies to mention you but I also need your experties 🙂

[wdx223_Daniel]

@Anonymous  please try the code like this, you might do some adjustments to fit in your model

SmoothedForecast:=if(isempty(previousmonth(dates[date],-1,month)),blank(),if([Previousmonth],[weight]*[auctualAmount]+(1-[weight])*[Previousmonth], [auctualAmount]))

[Anonymous]

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 · Accepted solution]

@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.

[Anonymous]

Yes I agree with you 😞 it can't be called columns result on its column..
This is sad 😞