First numeric value in table

[Michiel_QV_Fan]

Hi, I need to find the first value in a table:

The table consists of these dimensions:

• ProductID
• reporting month
• country

Fact:

• Amount

And the values are a running sum where the first value is the start value.

I want to calculate the monthly difference which is easy but I do not get the starting value for each ProductID, reporting month etc. right. I keep on finding the first value of the total table or the last value of the previous product etc.

I tried previous functions, min(reporting month) in group by, peek etc but no luck so far.

[Anil_Babu_Samineni]

Better to provide Sample data

Use something like below

=FirstSortedValue(Amount, -Aggr(Sum(Amount),ProductID))

[gardenierbi · Accepted solution]

Did you try with FIRSTSORTEDVALUE ?