Need to have calculated measure with reference of the same column previous value

[Chinna_1731]

Hello There,

I have situation where i need to calculate previous month, sameperiod last year in a measure however where in the measure first row value should be calculated reference for 2nd, 3rd, 4th and goes on...

I need a calculation result as below : 
Value_to_exponental = (0.2*Same_Period_LY)+((1-0.2)*Previous Row value)

For the first result row value it should consider Pre_Month measure and then it should take value from the current measure

[mangaus1111 · Accepted solution]

Hi @Chinna_1731 ,

you can use this measure

Did I answer your question? Mark this post as a solution if I did!

[v-yalanwu-msft · Accepted solution]

Hi, @Chinna_1731 ;

Try those measures:

Pre_month = CALCULATE(SUM('Table'[Invoice Processing]),DATEADD('Table'[date],-1,MONTH))

Same_period_ly = CALCULATE(SUM('Table'[Invoice Processing]),DATEADD('Table'[date],-12,MONTH))

Value_to_exponental = (0.2*[Same_period_ly])+((1-0.2)*[Pre_month])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mangaus1111]

you can copy this measure

Value Previous_Row =

VAR MaxDate = MAX('Table15'[Date])

RETURN

IF(

    HASONEVALUE('Table15'[Date]),

                MAXX(

                    FILTER(

                           ALL('Table15'),

                          'Table15'[Date] < MaxDate

                         ),

                   'Table15'[Value]

                 )

    )

[mangaus1111 · Accepted solution]

Hi @Chinna_1731 ,

you can use this measure

Did I answer your question? Mark this post as a solution if I did!

[PBI_Helpline]

you can use OFFSET() Function to get previous row from a Table visual, This function will not work in a calculated column, and if you need it check out below.
https://youtube.com/shorts/GxnK-FAPTAY?feature=share

[amitchandak]

@Chinna_1731 , If you need the last month and the same period last year

You can have two measures like

Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Month))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

this month = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))

[Chinna_1731]

Thanks for the response buddy!

However it doesn't seems fulfill the ask and can you please re-look into it