The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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 🙂
Solved! Go to 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
Hi @Migscruz ,
Has the problem be solved? Please consider mark the answer as solution if it works for you.
Best Regards,
Jay
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
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |