Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
You may use EARLIER Function or Variables in DAX.
You may use EARLIER Function or Variables in DAX.
Thank you, Variables help me very much.
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |