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()
As a new Power Bi user, it is the first TH-cam that gives all the necessary details to build my own calendar table. I also appreciate the pace. Very well presented and explained. Thank You!!
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?
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.
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?
@@SQLBits ciao la traduzione in italiano dall’inglese non è ottimale su TH-cam comunque fa piacere sapere che alcuni italiani in questo campo sono delle eccellenze
@@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
Excellent explanation and demo from Marco. Quite helpful! Thanks.
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()
As a new Power Bi user, it is the first TH-cam that gives all the necessary details to build my own calendar table. I also appreciate the pace. Very well presented and explained. Thank You!!
Thank you!
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?
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.
Great explanation,as ever
Magnificent!
Many Thanks
The best explanation about DATESYTD I've ever seen.
Brilliant!!
Also the entire video is quite helpful!
Thank you so much!
Glad it was helpful!
con la fortuna di avere in italia 2 guru di dax purtroppo i video sono in inglese .............................
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?
@@SQLBits ciao la traduzione in italiano dall’inglese non è ottimale su TH-cam comunque fa piacere sapere che alcuni italiani in questo campo sono delle eccellenze
@@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