Forum Discussion
Solved
calculation not working
Hi! I am trying to pull what my next week forecast is, but the measure is not pulling through any information. Any ideas? As you can see in the screen shot it is summing but not filling in the rows....
i couldnt get the file to open so that was why i was asking, but i just figured it out. Its because the porgram didnt like i had multiple many to many relationships to the dates table for the walmart week. I changed the one going to my past sales history to a single instead of both relationship and it works and keeps everything else working as well.
Do 'Walmart Projection'[Walmart Week] and Dates[Walmart Week] have the same type? I tried to reconstruct your example and it worked fine.
But at the end i guess you should tell us a little bit more about your data model.
But at the end i guess you should tell us a little bit more about your data model.
Hi!
Yes they are the same. Below are the tables i am using to input the information into Power BI.
relationships -
- Dates Table Walmart Week to Projections Walmart Week
- DC List Regional DC number to Projection Regional DC number
- DC List Regional DC number to DC Inv Regional DC number
I use a DC listing to get all the information by DC. as you can see below, it will sum the information, but not put it into each row.
The dates table is just an extended dates table with a walmart week included.
DC inventory
| distribution_center_number | out_of_stock_case_quantity_this_year | warehouse_packs_shipped_to_store_this_year | OH | OO |
| 6006 | 0 | 0 | 0 | 0 |
| 6009 | 0 | 0 | 0 | 0 |
| 6010 | 0 | 0 | 0 | 0 |
| 6011 | 0 | 0 | 0 | 0 |
| 6012 | 0 | 0 | 1 | 0 |
| 6016 | 0 | 0 | 0 | 0 |
| 6017 | 0 | 1 | 12 | 0 |
| 6018 | 0 | 0 | 0 | 0 |
| 6019 | 0 | 0 | 0 | 0 |
| 6020 | 0 | 0 | 0 | 0 |
| 6021 | 0 | 0 | 1 | 0 |
Projections.
| Regional DC | Store Number | Walmart Week | Unit Forecast |
| 6094 | 121 | 202429 | 8 |
| 6068 | 1148 | 202429 | 19 |
| 7026 | 3620 | 202429 | 4 |
| 6066 | 262 | 202429 | 2 |
| 6031 | 4451 | 202429 | 21 |
| 6036 | 5673 | 202429 | 13 |
| 6092 | 2339 | 202429 | 1 |
| 7039 | 5438 | 202429 | 3 |
| 6054 | 4436 | 202429 | 19 |
| 6027 | 2129 | 202429 | 4 |
| 6066 | 684 | 202429 | 28 |
| 6054 | 510 | 202429 | 8 |
| 6016 | 3391 | 202429 | 6 |
| 7035 | 2026 | 202429 | 3 |
| 6030 | 2885 | 202429 | 3 |
| 7045 | 2809 | 202429 | 8 |
| 6048 | 1204 | 202429 | 16 |
| 7039 | 3434 | 202429 | 3 |
| 6070 | 1060 | 202429 | 11 |
| 6038 | 3221 | 202429 | 2 |
| 6048 | 521 | 202429 | 50 |
| 6054 | 6998 | 202429 | 2 |
| 6009 | 3734 | 202429 | 1 |