Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Store measures in new table daily

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. 

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User
Anonymous
Not applicable

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. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors