Forum Discussion

ebrownretail's avatar
ebrownretail
Resolver I
2 years ago
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....
Need Help
  • ebrownretail's avatar
    ebrownretail
    2 years ago

    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. 

mostho's avatar
mostho
Helper II
2 years ago

1. its the same as yours.
2. you can look in my pbix.

ebrownretail's avatar
ebrownretail
Resolver I
2 years ago

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.