Previous Row Text value of subgroup in coloumn

[Anonymous]

Hi,

As can be seen the pic below, there are subgroups of number. What i want is that for a particular incident, the subsequent row shall give the previous row value in a new coloumn, when sorted in date wise order ( for the same i have created Index col too!).

The formula which i use for fetching previous text value is as per the pic below, but is also capturing indexes of oter Number coloumn and giving way off results.

Please help the Power BI Community

[Anonymous · Accepted solution]

hey, found the solution. Posting here so that it can help fellows in future if they face similar issue.

PreviousText1 = CALCULATE(MAX('Previous Row'[Value]),FILTER(ALLEXCEPT('Previous Row','Previous Row'[Number]),'Previous Row'[Index]=EARLIER('Previous Row'[Index])-1))