Forum Discussion
Helper IIIncome Statement Matrix
My suggest is, rather than try to set up a many to many relationship, is to build a table that holds all of the heirchy details in it by your account code. Then you can use these columns within your slicers and simply connect this single account table to your actuals table.
I'm suggesting you effectively merge 2 of your tables into one, so you can end up with a single table created as part of the import to ensure you have a 1 to many relationship.
Helper IIAnd for information, this is something like what I'm trying to achieve. These are the data. I would like to show the Actual (data) as a column, but then add a Gross Profit percentage for the Actual data measure, somewhere in the Gross Profit Category, or at least right after, so it is logically connected to it. If that is completely impossible, I would like to at least put all the measures at the end, but still in the Actual column, so that I can have one calculated measure for Actual, one for Budget, etc, for several items (such as GP%, etc). But I'm really struggling for how I can combine data with measures in this way.
My suggest is, rather than try to set up a many to many relationship, is to build a table that holds all of the heirchy details in it by your account code. Then you can use these columns within your slicers and simply connect this single account table to your actuals table.
I'm suggesting you effectively merge 2 of your tables into one, so you can end up with a single table created as part of the import to ensure you have a 1 to many relationship.