I have a budget report that is currently built in excel. I will attach photos. What I want to have in Power BI is the same capability I have in my excel report. The actual column changes based on the current month period. So, for example in my screenshot it shows january, and febuarry because the current month period at the time was Feburary. So it will show all the actuals up to Febauary. Then it has all the budget numbers for the following months. The dynamic part of this is getting the Power Bi report to replace the Budget Of March-23 with the Actual of March-23 when the period becomes 3. If this doesn't make sense I can explain more. Thanks!
It is possible. If you can create separate tables for Budget, Actual & Date, that will be easy for you.
Use following logic.
If Selected month in Date Table equal or less that current month number, then get the value from Actual Table else get the value from Budget Table.
@Power5 If you put sample data in the pbix file and share using one drive/google drive it will help to provide the solution. Remove any sensitive before sharing.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.