06-06-2018 12:53 PM - last edited 06-06-2018 14:29 PM
Haha I had to look that quote up, but you're the first one who spotted the avatar pic 🙂
I tried your suggestion but couldn't get it to fully work, and then landed on this calculation which did the trick for me:
CALCULATE( SUM(calculation), DATESBETWEEN(_Date[Date], DATE(1901,1,1), LASTDATE(_Date[Date]) ) )
Thanks for getting me there!
Thank you for your repsonse and I absoletly like it. However I need a dynamic month over month average with variance and percentage. I'm not sure how to apply your methodology to this.