The following is a DAX formula you can use to create a calculated column that shows "next year's" value in "this year's" row. You can easily adapt this to show "yesterday's" amount or "tomorrow's" total as well. It can be…
Generate and send reports, files or lists regularly with Microsoft Flow's "recurrence" trigger.
Create a calculated column in your Power BI data source to correct time zones.
Learn about licensing limitations in Power BI report sharing, and see two ways to embed/publish your reports to SharePoint so a limited audience or everyone can view and manipulate them,
Learn how to set up your datasets to automatically, regularly refresh your Power BI reports.