Forum Discussion
one top row data
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
Hi ,
I tried to make an example. I just want Exponential Smoothing column
PBX
https://easyupload.io/gouz99
Data and Sample
https://easyupload.io/u81aea
Thank You
Hi ForzaMami ，
According to the information inside the latest reply you gave, the result of the current item is calculated based on the result after the previous item is calculated. And as tamerj1 said, it involves recursive calculation, I'm afraid it's difficult to achieve what you need with DAX...
Best Regards
Hi ForzaMami
It is complicated but actually there might be a solution. Following is a silution based on a calculated column. Not sure if this is what you are looking for. https://we.tl/t-k7c9RgpgGwExponential = VAR a = 0.5 VAR CurrentDate = Sales[Year_Month] VAR FirstDateEver = CALCULATE ( MIN ( Sales[Year_Month] ), REMOVEFILTERS ( ) ) VAR FirstAmount = MINX ( FILTER ( Sales, Sales[Year_Month] = FirstDateEver ), Sales[Sales] ) VAR T1 = FILTER ( Sales, Sales[Year_Month] < CurrentDate ) VAR PowerNum1 = COUNTROWS ( T1 ) - 1 VAR Value1 = IF ( PowerNum1 >= 0, FirstAmount * POWER ( a, PowerNum1 ) ) VAR Value2 = SUMX ( T1, VAR PowerNum2 = COUNTROWS ( FILTER ( T1, Sales[Year_Month] >= EARLIER ( Sales[Year_Month] ) ) ) - 1 VAR Amount = MAXX ( FILTER ( T1, Sales[Year_Month] = EARLIER ( Sales[Year_Month], 1 ) + 100 ), Sales[Sales] ) RETURN POWER ( a, PowerNum2 ) * Amount ) RETURN Value1 + Value2
