Find the date and price change with in the Week.

[tabisen1]

Dear All,

Can any one help me out to resolve the issue of finding the date and price change in between last Monday to current Monday .

I want the Table as below

But table Appearing like this

[sunny_talwar]

Try attached

[tabisen1]

Dear Sunny,

Thanks for the prompt replay but my query is not to find the price of monday.

My query is find the price change it may be high or less. but FirstSortedValue is giving the highest or lost value in the week range.

if price change 3 or 4 time in a week then FirstSortedValue is giving the null value.

Help me out to solve this issue

[tabisen1]

[sunny_talwar]

If it did change 3-4 times, what do you intend to see? All of them in different rows? Avg of all the changes?

[tabisen1]

Dear Sunny,

I want to find the first change in the price.

Exp. I want to pick the first price change between 25.01.2016 (mon) to 01.02.2016 (mon)

25.01.2016 price is 305 and if it change to 309 / 300 on 28.01.2016 and again it change on 29.01.2016 to another no. but i want to pick first change if it does not change it will give null else no.