Hi all,
I'm very new to Power Automate but typically uses Power BI and I have a couple of questions. I've been trying to save the solution to a DAX expression in power bi as that solution changes everytime the dataflow is updated but I found that might be impossible to do. I stumbled on the idea of using Power Automate to store the solution in an excel workbook, google sheets, or a sharepoint list.
Would it be possible to use Flow to automatically update the work book with new solutions daily or even weekly while also keeping the previous solutions in that workbook? If so, how would that be done?
If my question isn't clear, lets think about it this way; imagine in an office of about 500 people, various people open tickets for the IT department to solve issues. The data of the status of each request is recorded and now in Power BI we try to visualize this data and end up writing a dax to count the number of requests that are still open. But this number is subject to change everyday as the IT departments either closes a couple in one day or receive more another day.
So would there be a way to store that number from the previous day so we can track the change in number of open cases? CanI use power automate for this? If so, how?
Thanks y'all!
