Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Store measures in new table daily


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. 




Super User
Super User
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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors