This Function

[DenisCh]

Hello,

please it is possible in Power BI something like This() function.

I have a table with changes in status of tickets and I want to fill column with previous change with this ticket. Table contents ID, ticket Number, creation Date, old state and new state. Creation date is date when this change was made. 

LastChange = MAXX(FILTER(ObjectChange; ObjectChange[CreationDate].[Date] < This.ObjectChange[CreationDate].[Date] && ObjectChange[ObjectId] = This.ObjectChange[ObjectId]);ObjectChange[Id])

Is something like this possible?

Thank you

[v-chuncz-msft · Accepted solution]

@DenisCh,

You may use EARLIER Function or Variables in DAX.

[DenisCh]

Thank you, Variables help me very much.