Using a top row

[ForzaMami]

It's a little hard to explain, I need to use the same formula in a single dax formula, the one in the top row. I'm trying to power the "Exponential Smoothing" column in the excel below. Is something like this possible ?

Thanks

[ForzaMami]

Hi ,

I just want Exponential Smoothing column

PBX
https://easyupload.io/gouz99

Data and Sample
https://easyupload.io/u81aea

Thank You

[ForzaMami]

did i want something so hard 🙂

[BA_Pete]

Hi @ForzaMami ,

You should be able to set it as a variable:

_expoSmoothing =
VAR __minSatis =
CALCULATE(
    MAX(yourTable[Satis]),
    FILTER(
        yourTable,
        yourTable[Year_Month] = MIN(yourTable[Year_Month])
    )
)
RETURN
([thing1] * [thing2]) + ([thing3] * __minSatis)

Pete

[ForzaMami]

I need to take the calculation from the previous line as a variable. This did not happen 😞

[BA_Pete]

Sorry, I misunderstood your requirement.

Add an index column to your table and set a variable like this:

_expoSmoothing =
VAR __lastExpoValue =
LOOKUPVALUE(
    yourTable[Exponential Smoothing],
    yourTable[Index],
    yourTable[Index] - 1
)
RETURN
([thing1] * [thing2]) + ([thing3] * __lastExpoValue)

[ForzaMami]

sorry i think i didn't explain.  same formula need same formula value 

Exponential_1 =

([Input2Values]*[Measure Last Period]) + ([Input2Values] * [Measure Last Period](Wrong) )

20200301 = (0,5*633.973) + ( 0,5*4.076.361 ) = 2.355.167 must

20200401 = (0,5*766.859) + ( 0,5*2.355.167 )= 1.561.013 must