Тёмный

Explaining unexpected results with DAX Time Intelligence functions - Unplugged #17 

SQLBI
Подписаться 109 тыс.
Просмотров 5 тыс.
50% 1

Why the standard DAX time intelligence functions might return unexpected results? Discover how DATEADD and SAMEPERIODLASTYEAR work under the hood!
Read more about the "unplugged" format: www.sqlbi.com/...
#unplugged

Опубликовано:

 

30 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 12   
@PowerEliteStudio
@PowerEliteStudio 3 года назад
Thanks Marco for helping us understand these behaviors
@wmfexcel
@wmfexcel 3 года назад
This is super interesting. Thanks for the details details. Learn so much from you! 😉
@Anthony_Lecoq
@Anthony_Lecoq 3 года назад
Haha ;) it is so limpid now. This video match perfectly with the 4 steps in CALCULATE presented by Alberto. You guys are the sun in clouds ;)🌞🌞
@beginho2454
@beginho2454 3 года назад
not easy handle date caculation haha thank you, Macro, great teacher. ;)
@smartdata678
@smartdata678 3 года назад
Beautifully explained. Thank you!
@williamrodriguez2694
@williamrodriguez2694 3 года назад
The bug around 6:30 could have been fixed by hitting the esc key. I submitted something similar a few months back (to your github) and a dev responded with the technicals of why it happens.
@marcorusso7472
@marcorusso7472 3 года назад
I know, and I think I tried to press ESC but it didn't work that time...
@mailmerink
@mailmerink 3 года назад
Thank you for sharing the same
@marilenadonofrio9787
@marilenadonofrio9787 3 года назад
Very interesting...grazie Marco
@ed2921
@ed2921 3 года назад
Brilliant! Another great video.
@sane7263
@sane7263 2 года назад
Amazing Marco! ❤
@marilenadonofrio9787
@marilenadonofrio9787 3 года назад
Really interesting!
Далее
Consecutive days with no sales - Unplugged #18
27:35
Просмотров 17 тыс.
Optimizing time intelligence in DirectQuery
18:09
Просмотров 6 тыс.
ТАРАКАН
00:38
Просмотров 1,2 млн
Louise,  Mergers & Acquisitions
2:23
Просмотров 3
Working below a DAX formula’s granularity
15:16
Просмотров 20 тыс.
My number 1 trick for TIME INTELLIGENCE  | Power BI DAX
11:13
When to use KEEPFILTERS over iterators
18:56
Просмотров 48 тыс.
Auto-exist on clusters or numbers - Unplugged #22
41:20
Time Intelligence in Power BI
50:27
Просмотров 7 тыс.