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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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 , refer if this blog on similar lines can help?

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.