cancel
Showing results for 
Search instead for 
Did you mean: 

Time Intelligence "The Hard Way" (TITHW)

Super User IV
23763 Views
basroozen Helper IV
Helper IV

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 🙂

 

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 Helper V
Helper V

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

Greg:

 

I'll give it a try.

 

 

THanley Helper I
Helper I

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 Advocate II
Advocate II

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

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

SonaSingh123 Helper IV
Helper IV

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

Highlighted
sach18 Helper III
Helper III

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

Great. Yipeee, That solved my issue. Thanks....