cancel
Showing results for 
Search instead for 
Did you mean: 

Time Intelligence "The Hard Way" (TITHW)

Super User
5713 Views
basroozen Regular Visitor
Regular Visitor

Re: Time Intelligence "The Hard Way" (TITHW)

Haha I had to look that quote up, but you're the first one who spotted the avatar pic Smiley Happy

 

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!
Bas

MojoGene Member
Member

Re: Time Intelligence "The Hard Way" (TITHW)

Greg:

 

I'll give it a try.

 

 

THanley Regular Visitor
Regular Visitor

Re: Time Intelligence "The Hard Way" (TITHW)

Hi Greg,

 

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.

 

Tom