Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Weekly average when daily calculation involves lag (PREVIOUSDAY (or DATEADD('Date', -1, DAY)))

I have the following dataset:     The formula for storage flow is HeldInStorage (day X) + Supply (day X) - Demand (day X) - HeldInStorage (day X - 1).   So for a daily measure, the followi...
  • daXtreme's avatar
    daXtreme
    4 years ago

    Hi Anonymous 

     

    What exactly does it mean "the formula fails"? You have not shown any output. At first glance the formulas seem to be OK but without seeing the wrong results and the expected output it's not possible to diagnose.

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous hard to say, need more info. If you want I'm available now for a quick zoom call to look together