Help with dax table

[Migscruz]

Hi to all! i'm new at the forum  🙂

This is my data and the filters should be brand, sub brand, product family, sector and month:

And i need to look like this  in a matrix:

The formula por example in the row of product 4 is: Sales product 4 (300,000) - sales product 1 (200,000) = 100,000 and so on for each one.

How can i do this? The file is here Data example Thanks to all 🙂

[v-jayw-msft]

Hi @Migscruz ,

Has the problem be solved? Please consider mark the answer as solution if it works for you.

Best Regards,

Jay

[lbendlin · Accepted solution]

create a reference copy of your data table in Power Query, then link both tables via the product name, and then create a measure that uses a CROSSFILTER(,,none) pattern