Forum Discussion

DenisCh's avatar
DenisCh
Frequent Visitor
8 years ago
Solved

This Function

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