4 Replies Latest reply on Dec 18, 2017 11:40 PM by Shinichiro Murakami

# How to get last 3values and First 3 values from a measure

Hi All,

I would like get

i) last 3 values of a measure and

ii) first 3 values without the help of any other columns.

Kindly provide your suggestions or solutions to achieve this.

To say more clearly, in the workbook I have attached there is only one column named sales which consists of 24rows.But I want to display the sum or avg of firs three values 732,262 and 732.

Likewise I would like to get the sum of last 3 values 23,19,60.

Have attached a twbx for that.I haven't tried since I did not have a clue on how to achieve this.

Thanks for helping!

Thanks & Regards

sai lakshmi

• ###### 1. Re: How to get last 3values and First 3 values from a measure

Hi Sai,

Very limited information, but does this work?

fyi

Table Calculation Functions

Thanks,.

Shin

1 of 1 people found this helpful
• ###### 2. Re: How to get last 3values and First 3 values from a measure

Hi Schinichiro,

Thanks for the quick reply but it didn't serve my purpose.

Regards

sai lakshmi

• ###### 3. Re: How to get last 3values and First 3 values from a measure

Hi All,

To say more clearly, in the workbook I have attached there is only one column named sales which consists of 24rows.But I want to display the sum or avg of firs three values 732,262 and 732.

Likewise I would like to get the sum of last 3 values 23,19,60.

Regards

sai lakshmi

• ###### 4. Re: How to get last 3values and First 3 values from a measure

Hi Sai

See below.

'

Thanks,

Shin

1 of 1 people found this helpful