Forum Discussion

Eric667's avatar
Eric667
Regular Visitor
10 years ago

DAX - Running total until Yesterday using Time Intelligence

Hi there!   I have been trying to calculate a Running Total until yesterday using the following formula:   Total Until Yesterday = CALCULATE(sum('Table'[Table]), DATESBETWEEN(Datetable[Date], "1-...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Eric667,

 

   can you provide me an example dataset? Because I tried with a dummy dataset and I obtained a correct chart with the ability to drill down the date hierarchy.

 

#I'M Not An Expert#

 

 

Eric667's avatar
Eric667
Regular Visitor
10 years ago

Hi Anonymous, thanks for trying! I will see if i can draw a sample with the same characteristics. May I ask if you used the formula I wrote here?

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Yes, I've used your formula.