
Announcements
Hi Guys - Please see screenshot below: I've posted this to the Power BI forum also, but thought there may be a way for power automate to do this and also refresh the power BI dataset on a monthly basis, which isn't currently available in the Power BI service.
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.