Hi,
I am trying to figure out a formula to calulate sales projections using two different tables. I created a relationship between the two tables via my "Item" column.
Table 1 contains previous fiscal year sales data
Table 2 contains expected percentage increase per month per ITEM
I created measures totalling each of my monthly sales data in Table 1 i.e. a measure for Total Sales in June, Total Sales in July etc. E.g. FM19Apr = CALCULATE(sum('Sales History'[Units Sold]),FILTER('Date','Date'[Fiscal Year]="FY18"),FILTER('Date','Date'[Month]=4))
I am trying calculate the sales increase per ITEM per Month. Note, I also have a data table.
E.g. Table 1:
| TRANDATE | ITEM | Units Sold |
| 2015-01-05 | 1261021 | 408 |
| 2015-01-22 | 1261021 | 204 |
| 2015-03-06 | 1261021 | 204 |
| 2015-05-26 | 1261021 | 408 |
| 2015-05-29 | 1261021 | 204 |
| 2015-06-18 | 1261021 | 204 |
| 2015-07-09 | 1261021 | 204 |
| 2015-07-23 | 1261021 | 408 |
| 2015-08-06 | 1261021 | 204 |
| 2015-09-18 | 1261021 | 204 |
| 2015-09-30 | 1261021 | 408 |
| 2015-10-19 | 1261021 | 204 |
| 2015-11-30 | 1261021 | 204 |
E.g. Table 2:
| ITEM | June | July | August | September | October | November | December |
| 1261021 | | | | | | | |
| 1261023 | | | | | | | |
| 1261024 | | | | | | | |
| 1261026 | | | | | | | |
| 1261027 | | | | | | | |
| 1261028 | | | | | | | |
| 1261029 | | | | | | | |
| 1262021 | 0.1 | | 0.1 | 0.1 | | | |
| 1262022 | 0.1 | | 0.1 | 0.1 | | | |
| 1262023 | 0.1 | | 0.1 | 0.1 | | | |
| 1262024 | 0.1 | | 0.1 | 0.1 | | | |
| 1262025 | 0.1 | | 0.1 | 0.1 | | | |
| 1262026 | 0.1 | | 0.1 | 0.1 | | | |
| 1262027 | 0.1 | | 0.1 | 0.1 | | | |
| 1281001 | 0.25 | 0.25 | 0.25 | 0.25 | | 0.25 | 0.25 |
| 1281002 | 0.25 | 0.25 | 0.25 | 0.25 | | 0.25 | 0.25 |
| 1281003 | 0.25 | 0.25 | 0.25 | 0.25 | | 0.25 | 0.25 |
| 1281004 | 0.25 | 0.25 | 0.25 | 0.25 | | 0.25 | 0.25 |
