Forum Discussion

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
8 years ago
Solved

Previous Day Value

Why does this work...   Order Value Prev Day = CALCULATE( SUMX(orderLines, [Amount] * RELATED(Order_Types[Sign])), FILTER( orderLines, [Date] = MAX('Dim Date'[Date]) ), ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Nope, ALL just removes all of the context filters but not the relationships. Let me see if there is a way to do that but I'm not sure. 

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
8 years ago

Yes, sorry, rushed it, should be - 1.  Edited to fix.

 

In answer to your question, I do have dates one day less for all the values selected and I use ALL(orderLines) to open up the context to the whole date range.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Again, tough to say without the data to replicate. But, if you have a relationship between your two tables based on Date. Then you will never have a match between them where date in one table matches -1 date from another table. Does that make sense?