Forum Discussion

ForzaMami's avatar
ForzaMami
Regular Visitor
4 years ago

one top row data

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 ...
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi ForzaMami 

you may try

 

Exponential Smoothing =
VAR CurrentYearMonth =
    MAX ( Table[Year_Month] )
VAR PreviousStatus1 =
    CALCULATE ( [Status], Table[Year_Month] = CurrentYearMonth - 100 )
VAR PreviousStatus2 =
    CALCULATE ( [Status], Table[Year_Month] = CurrentYearMonth - 200 )
RETURN
    IF (
        NOT ISBLANK ( PreviousStatus1 ) && NOT ISBLANK ( PreviousStatus2 ),
        IF (
            ISBLANK ( PreviousStatus1 ),
            PreviousStatus2,
            0.5 * PreviousStatus1 + 0.5 * PreviousStatus2
        )
    )

 

ForzaMami's avatar
ForzaMami
Regular Visitor
4 years ago

Hi,

 

Dont work. If you want to get the 1st and 2nd months retrospectively, it doesn't work either.

 

 

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    ForzaMami 

    Can you please right the expected results with explanation in this same screenshot?

    • ForzaMami's avatar
      ForzaMami
      Regular Visitor
      4 years ago

      Hi ,

       

       

       

      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
       

       

       
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi ForzaMami ,

        You can create a measure as below to get it:

        Exponential_1 =
VAR _curym =
    SELECTEDVALUE ( 'Table'[Year_Month] )
VAR _selalpha =
    SELECTEDVALUE ( 'Table'[Alpha] )
RETURN
    _selalpha
        * SUMX (
            FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Year_Month] <= _curym ),
            [Measure Last Period]
        )

        If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

        How to upload PBI in Community

        Best Regards