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.
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 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.