Forum Discussion
Snapshot monthly ticket data
Is it possible to take a snapshot of a single field on a month-by-month basis and use it to report on?
I want to show how much time was taken on a project each month but the time taken field will just override each time so I only have a total for the whole project rather than by month. The date connected to it is the created date so the time taken all sits in the month of it being created.
Ideally I would have a field for each month and I can subtract the previous month from the current month to get a monthly figure but I'm not sure it's possible?
1 Reply
khaycock , there was a DAX append method discussed in a couple of blogs. see if that can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/You may have to create aggregated table before that
