Forum Discussion
Dashboard for Daily reports | Acquire difference
Hello,
I have daily reports sent on regular intervals and I wish to have the data compared.
Through Power automate I can place my report however I want, but appreciate if anyone has ideas compare the data of previous one with the current one and let know the difference.
What I am thinking is to revolve the files each day upon arrival in Power automate so that PowerBI can get hold of current data file and previous data file and compare utilizing Merge Step.
But still thought of pushing my luck by posting to check if there is any better ideas through PowerBI.
😃
2 Replies
- Fowmy
Super User
Anonymous
As long as you have the date and time stamps for the data sources that you connect from Power Query, automating the comparision between current and previous date datasets and producing a variance report using Power Query is the most effective and easy process which I will go for.________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
