Time Intelligence in Power BI

[@louisettebizier4313]

As a new Power Bi user, it is the first KZbin that gives all the necessary details to build my own calendar table. I also appreciate the pace. Very well presented and explained. Thank You!!

[@SQLBits]

Thank you!

[@alexandre5150]

The best explanation about DATESYTD I've ever seen. Brilliant!! Also the entire video is quite helpful! Thank you so much!

[@SQLBits]

Glad it was helpful!

[@DataBeach]

Excellent explanation and demo from Marco. Quite helpful! Thanks.

[@TheEziolino]

Great explanation,as ever

[@Lotaristo]

Hi, i've seen on 16:53 that you new created measure automatically converted to currency format. In my current work it happens very often and i'm already tired to convert them back to general format. So, is the a way to somehow disable automatic conversation to currency format?

[@pabeader1941]

What is Time Intelligence in Power BI? It's a misnomer. It should have been called Period Intelligence. I'm still waiting for Time Intelligence. I would really like to see DATEADD that includes hours minutes and seconds like SQL does. That would make most of my reporting much easier to create.

[@karannchew2534]

Create Date Table with DAX. Create Date hierarchy. Use inactive relationship. TotalM/Q/YTD() // Previous Month DATEADD() // Same dates but shifted by specific intervals SAMEPERIODLASTYEAR(). DATESADD(). // Nested DATESYTD( SAMEPERIODLASTYEAR() ). // The whole period PREVIOUSYEAR() PREVIOUSMONTH() PARALLELPERIOD() DATESINPERIOD()

[@ubonguttah]

Many Thanks

[@mategombas771]

Magnificent!

[@schenas]

con la fortuna di avere in italia 2 guru di dax purtroppo i video sono in inglese .............................

[@SQLBits]

I'm really sorry we dont have a version in Italian. I dont know if this will help but you an get the transcript of the session from the "..." button below the video. Perhaps you can pass this through a translation service? [Google translate English > Italian]: Mi dispiace davvero che non abbiamo una versione in italiano. Non so se questo ti aiuterà, ma ottieni la trascrizione della sessione dal pulsante "..." sotto il video. Forse puoi passare questo attraverso un servizio di traduzione?

[@schenas]

@@SQLBits ciao la traduzione in italiano dall’inglese non è ottimale su KZbin comunque fa piacere sapere che alcuni italiani in questo campo sono delle eccellenze

[@SQLBits]

@@schenas It could be worthing sending Marco a message via social media to and see if he has any Italian sessions Potrebbe valere la pena inviare a Marco un messaggio tramite i social media e vedere se ha sessioni di italiano