March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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
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
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |