What I think you want to do here Karen has a few steps.
You will want to create a few measures to ultimately create what you need.
So instead of just having ‘total sales’ I think you’ll want to create for example Company1 Sales, Company2 Sales etc etc.
To do that what you can do is use CALCULATE( [Total Sales], Company = x )
Then you may want to create one measure that has all those new measures inside it. For this you may want to look at SWITCH/ TRUE logic. There’s a few video tutorials I’ve created on this but the same idea it mentioned in this tutorial about dynamic visuals. This way you integrate these new measures into one measure
The next and last thing you might want to do is create a new table that just has
Then draw relationships from this table down to each column in your date table with the unique financial years for each group. This is how you can get your consolidation ultimately, because you’ll then use the FY dimension in this table and it will filter this new measures concurrently based on the FY you select.
Ok there’s a bit to this, but not the easiest thing to solve in Power BI.
Hopefully this assists and gives you a few ideas, any question reply here. Chrs, Sam