Explaining unexpected results with DAX Time Intelligence functions

No video

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

Рет қаралды 5,382

3 жыл бұрын

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

Пікірлер: 12

@PowerEliteStudio 3 жыл бұрын

Thanks Marco for helping us understand these behaviors

@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 ;)🌞🌞

@wmfexcel 3 жыл бұрын

This is super interesting. Thanks for the details details. Learn so much from you! 😉

@smartdata678 3 жыл бұрын

Beautifully explained. Thank you!

@beginho2454 3 жыл бұрын

not easy handle date caculation haha thank you, Macro, great teacher. ;)

@sane7263 2 жыл бұрын

Amazing Marco! ❤

@ed2921 3 жыл бұрын

Brilliant! Another great video.

@marilenadonofrio9787 3 жыл бұрын

Very interesting...grazie Marco

@mailmerink 3 жыл бұрын

Thank you for sharing the same

@marilenadonofrio9787 3 жыл бұрын

Really interesting!

@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 3 жыл бұрын

I know, and I think I tried to press ESC but it didn't work that time...