Forum Discussion
calculation not working
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.
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 |
as i said i tried to reconstruct a minimal example and it worked.
maybe you can see on my pbix some difference to yours.
Would you be able to paste the measure into the message? i can read it on the screenshot.
1. its the same as yours.
2. you can look in my pbix.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.