Forum Discussion
Post ProdigyCreate Dynamic Matrix Table
I found solution to my problem following Stachu directions in below link.
Solved: Create calculated row - Microsoft Power BI Community
Post ProdigyGreg_Deckler Thank you for your response. The data is in below format, only difference is row "spend" is not included and it is a calculated measure. Everything else is coming from P&L table. I would like create a dynamic matrix table like below and updated it based on slicer period selection. Hope this helps clarify. My report has confidential information because of that difficult to share. Thanks
Slicer Option: YTD, Last 4 weeks, and Last Year.
| 2021 | 2022 | |
| Sales | $100 | $110 |
| COGS | $50 | $55 |
| Spend | $10 | $11 |
| Profit | $40 | $44 |
| Contrbution | $30 | $33 |
Community Championdokat Really need mock data that emulates your real data. And your measure formula. So is your source data like:
| Category | Date | Amount |
| Sales | 1/1/2022 | $10 |
| Sales | 1/2/2022 | $20 |
| Spend | 1/1/2022 | $5 |
| Spend | 1/2/2022 | $5 |
- dokat
Greg_Deckler below you will find the link to the sample data file. I included year ende 2021 and 2020 and latest 4 weeks data.
Calculation for "Spend" is Sales - Trade. All other PL lines comes from the data table. Thanks
https://www.dropbox.com/s/87dz0f9ibx30l3h/Sample%20Data.pbix?dl=0
2021 2022 Sales COGS Spend Profit Contrbution