Text field to show the selected filter

[Anonymous]

Hi, i want to do something like this

previousvalue1=

VAR _id =Query1[setDataId]

VAR _created =Query1[_startedAt]

VAR _previousDate = CALCULATE(MAX(Query1[_startedAt]),FILTER(ALL(Query1),Query1[setDataId] = _id && Query1[_startedAt] < _created))

RETURN

Query1.value1 where value1._startedAt= _proweviousDate

(the red part is the formula i dont know how to do)

Now, i can return the date of a previous value, but what  i want to return another column (value1) with the info of value1 in the previous registry. is that possible?

Thanks for your help!

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Finding-the-previos-occurrence-within-same-table-based-on-one/m-p/342607#M153516