Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have seen many questions on Snapshot. Most of them are about taking snapshots of data tables.
In my case I am looking of taking snapshots of matrix output table.
I have a large PBIX with our total Accounts Payable balance. The report has both the vendor invoices that have been approved for payment as well as those invoices that are still en route for approval. The datasets are refreshed daily and therefore the invoice status changes daily.
In one of the matrix tables I display the current position of our liabilities (Approved, Unapproved, Ready for payment).
This is a fluid dataset that is refreshed 2x a day. But I would like to take a snapshot of the position and put it in a separate table, so that I can report on the weekly change in position (basically the Dashboard snapshot but then stored in a table for reporting, not send as a picture to email).
Is there any way to do that?
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |