cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gtamir Member
Member

Time Intelligence

I read a lot about Time Intelligence but still don't understand the mechnisim of each formula. 

How the enging works exactly with DATESYTD.

What is the different between the tow folloing formulas?

Total Year To Date Internet =

TOTALYTD( SUM(FactInternetSales[SalesAmount]), 'DATE'[Date])

YTD2 Internet =

TOTALYTD( SUM(FactInternetSales[SalesAmount]), DATESYTD('DATE'[Date]))

Thanks Giora

2 REPLIES 2
Community Support Team
Community Support Team

Re: Time Intelligence

@gtamir ,

 

You may take a good look at https://www.sqlbi.com/blog/marco/2018/08/10/the-hidden-secrets-of-totalytd/.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gtamir Member
Member

Re: Time Intelligence

Yes I read the articles and others. They give example but I didn't find the technical explanation of how it works.

So I can't understand the difference between the tow examples I gave.