Create Performance history and save in new table within Power BI report/dataset

[StevenHarrison]

Hi Guys - Please see screenshot below:

Currently our Compliance Team do all this manually in a spreadsheet, so the 'Performance over previous 6 months' is a manual entry.

For the 'Performance in current month', I have created a number of measures that capture and display this, so my question is, at the end of the month can the '% compliant' values ringed in red be moved into a new Performance history table in the Power BI model/dataset and keep the last 6 months? There is no real time intelligence associated with this, as the counts etc are all on number of jobs. Any thoughts/ideas/comments more than welcome.

[lbendlin · Accepted solution]

Power BI has no memory, and no concept of historical snapshots. You need to do that in the upstream system.

[StevenHarrison]

Hi Thanks for confirming this, thought it was he case but just needed to throw it out there for comment.