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