Forum Discussion
Create a 'versus budget' as a table row
I have two tables, one for budget, one for actuals. Both tables have sales and profit. I want to create a Power BI table which has the columns - Sales... Profit I want to have the rows as...
This is great, but I'm not sure it works exactly for me. As I understand, calculation groups can be used for creating e.g. a YTD filter against any metric that you choose.
So you can select e.g. Sales, or Profit, and it would provide your time filter.
However, in my example, I have Sales and Profit actuals in one table, and Sales and Profit Budget in another table. And I want to compare the actuals to the budget for both metrics.
Does that make sense? Or perhaps I've not understand calculation groups properly.
THanks for your help