Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |