cancel
Showing results for 
Search instead for 
Did you mean: 

Time Intelligence "The Hard Way" (TITHW)

Super User
15893 Views
basroozen Member
Member

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

charleshale Regular Visitor
Regular Visitor

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

How would you add a measure to show the $ amount of lost customers for any customer?

SonaSingh123 Regular Visitor
Regular Visitor

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

YTD.png

Can you please help on this. This is my MTD data. My requirement is to create YTD for the same with opening. Please go through my PBIX file