Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@gtamir ,
You may take a good look at https://www.sqlbi.com/blog/marco/2018/08/10/the-hidden-secrets-of-totalytd/.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |