Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gtamir
Post Patron
Post Patron

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
v-chuncz-msft
Community Support
Community Support

@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.

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.