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.
I don't know what a 6 digit week is. If you want to successfully use Time Intelligence, there are many rules you must follow. There are different rules if you use a day level calendar and want to leverage in built time intelligence, and if you don't have a day level calendar, and want to write time based calculations. You have t shared any details about your calendar table or the way its joined, so I can't comment. You could read a couple of articles I wrote and I'm sure they will help you.
https://exceleratorbi.com.au/dax-time-intelligence-beginners/
https://exceleratorbi.com.au/power-bi-calendar-tables/
the 6 digit week is a year week combination. So this week is 202429 for the Walmart Week.