March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I've been searching for a while now.
The data source I am using is a list of all support tickets with their status, details, etc. Is it possible, using DAX or another method, to store the calculated result in a new "snapshot" table within the dataset, so that we can show the daily evolution of active tickets?
To give some more context;
The data source I am using is a list of all support tickets with their status, details, etc. One of the measures is showing the number of new tickets (current queue).
The report is refreshed every morning, but since the source is not historized, it's only showing the current number of active tickets at the time of the refresh.
@Anonymous , refer if this blog on similar lines can help?
Thank you, I use that exact page for other situations. My issue here is that a ticket can be closed and re-opened X amount of times.
To get active tickets you have to do a count of ID and filter on status = "Active". I don't see how I can combine that with the page you linked.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |