cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.