Forum Discussion
DenisCh
8 years agoFrequent Visitor
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
2 Replies
- v-chuncz-msftCommunity Support
- DenisChFrequent Visitor
Thank you, Variables help me very much.