Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
colverjustin
Frequent Visitor

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 Actuals, Budget, Versus budget

 

So 

 

.......................Sales............Profit

Actual.............. X...................X

Budget............ X...................X

vs Budget....... X...................X

 

Whats the cleanest way of creating this please? 

 

Do i need to create new tables? What DAX measures should I create?

 

Any help would be amazing.

 

Thanks so much

2 REPLIES 2
colverjustin
Frequent Visitor

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

amitchandak
Super User
Super User

@colverjustin , i think calculation groups can help

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.