Forum Discussion
DAX Help - complex calculation
Hello, I am encountering a roadblock in the DAX code I am trying to develop and would appreciate any guidance or support! Here is a picture of the work in progress (see below). The first lev...
Thank you for everyone's help. I am still running into the same issue, unfortunately. I'm providing some sample data to illustrate the issue further, this includes a data schema, and desired output.
Transactions
| Business Date | Item Pack PK | Promotion Detail PK | Units Sold |
| 1/1/2025 | 3 | 1 | 2 |
| 1/2/2025 | 3 | 558 | |
| 1/3/2025 | 4 | 5 |
Promotions
| Promotion Description | Promotion Detail PK |
| Bananas | 1 |
Items
| Item Name | Item Pack PK |
| Fresh Fruit Banana | 3 |
| Nuggies | 4 |
Date
| Date |
| 1/1/2025 |
| 1/2/2025 |
| 1/3/2025 |
| 1/4/2025 |
| 1/5/2025 |
Desired Result (Matrix) in Power BI
Data Model Schema
Sorry, the totals for the desired result should actually be: