Forum Discussion
Dax Calculation Between Dates
That's coming from the link you gave in your first message... ???
Anyway, you should have a connection between your fact tables (orders) and date table, isn't that the case ?
'Cause it's what I understood from your first message. Am I wrong ?
Okay, I don't know how that happened but that wasn't my link. I replaced it with a link to my actual file: https://drive.google.com/file/d/1NzAmW3rra0ZzImLWhgSbMyu88RESM7fi/view?usp=sharing
Sorry about the confusion. There isn't a relationship between the order ID numbers in my original file beacause it introduces ambiguity between other tables. I wish I could share my original file but I can't. Would it help to create a table that's just order ID numbers and try creating a relationship for that table to the other two. Or if I change the sources and have a table that has the order placed date and the order filled date in both how could I do it? I'm completely open to suggestions, this one is just beyond my current capabilities.