Why you should disable Auto Date/Time - May 2019 Power BI Desktop Update

One of the new features released in the May 2019 Power BI Desktop update is global disable Auto Date/Time feature. Do you know why? Let me show you in this video.
#powerweek #curbal #powerbi

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#POWERWEEK #CURBAL #POWERBI #POWERBIUPDATE #MVP

[brunof.s.]

Wow!


Super sweet! I wasn't even aware of this automatic creation of date-time calendar! sometimes i just look at my dataset, saw those hierarchies and thought: "damn, i must have wrongly clicked somewhere and made this mess".


It was PBI all this time!

[syrophenikan]

I taught a PowerBI class just yesterday, and I wish I had seen this sooner. I would have informed the students of this issue. I did promote your website (as I always do), so hopefully they will see this video. Thank you!!!!

[TomVanHecke-ix]

Hi Ruth, just love your videos. Clearly explained in a fun way :-)

[NaseerFarooqi]

Thanks Ruth, I was looking for not having Date Hierarchy in my transaction table.

[Sanj]

Super like. Thank you for showing it with the help of DAX studio.

[TMKJFun]

Thanks for this great information. When using my own Calendar table in models, should I still build a hierarchy for my date (from year, q, month and day fields in the table) or just use the fields directly without creating a hierarchy?

[belizatube]

Thanks a lot for this video, Ruth. Start doing this right now in my further reports.

[BigRedFishDad]

I know it is an older video but thanks your probably a fun person at work I love the videos... 5:50, yes I did it! I have been using a date table all along and I am like you and I hate all the carets and dropdowns on my date fields.

[juanaleman]

Excelente recomendación a tener en cuenta a la hora de construir nuestros informes, y no terminemos con un modelo muchisimo mayor al que debieramos. Muchas gracias Ruth!

[EricaDyson]

Lovely! Your style is fantastic. Thanks so much. Tell me, should the date table have dates well into the future or just dates that match entries in fact tables? I'm a newbie, as you can tell by the question!

[frankgovers]

Hi ruth, have you ever tested the quick measures, without marking the data table ?

[christopherhastings]

Nice explanation! This is my favorite of the updates!!!! :)

[learnspreadsheets]

If you tick “set as calendar table” it should do that automatically ;)

[marklund]

Hi Ruth, if I disable Auto Time Intelligence I appear to loose the date hierarchy? Is this something which can't be avoided? The main reason I want it is so that my line chart with date on the X axis has the Concatenate Labels option, which makes the presentation of the timeline much more attractive, with the 3 layers of dates. Thanks Mark

[brunof.s.]

Hey Ruth, is there any chance of a DAX FRIDAY video about this Dax function called "SELECTEDMEASURE" ? I've read the documentation but cannont think in a way of using it...

[Doomemdtrader]

Everyone: Make sure you deselect that function.
Me: NEVER!

I find it better to have multiple 'month' fields to pick from, than just 1. Also, so far, after my 5 GB Power BI file got reviewed, the date tables created by this function was actually relatively small... Why not just make life easy on yourself and keep them in.