How to get a DATE TABLE easily in Power BI

Do you use a central date table for your Power BI datasets? There is a LOT of POWER in having one. Adam shows you different ways to create one including a really simple easy option that's BANANAS!

REDUCE Power BI dataset size by 60% with ONE CHECKBOX???

Bravo for Power BI


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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #Dates #GuyInACube

[farhatwajidkhan]

The channel deserves way more subscribers. I was introduced to the channel more than an year ago by a colleague and this has been my go to channel ever since. Super informative! Thank you!

[WilliamRichterIII]

Man, I love your energy and your breadth of knowledge. I was a teacher in a previous life, so I'm self-teaching a lot of this in a new manufacturing analyst role. I share this to let you know you're an awesome teacher! Thanks for doing this!

[MilhouseBS]

I built our Date dimension from the sqlBI Date template last year. I love how they make it easy for a new user.

[RamonMoya-tx]

You guys are really good at making the difficult easy to understand. This was excellent! I did not know about Bravo, but I do now!

[pabeader]

Automatic Period Intelligence???? SWEET!!! Glad I watched this video. Thanks for making it.

[stinainsd]

This is bananas!!!! I cannot wait to download this when I get to work tomorrow!

[osPA]

How is it that you guys are NOT at 1M This was an amazing video and Bravo is

[gxsoft]

Bravo!
Thanks Guy, Thanks Marco Russo

I knew it, but
I didn't use to now, but with your EXCELLENT explanation, I going to use it!

Thanks a lot!
gab
Rio Cuarto, Argentina

[megapixelphotos]

Never heard of Bravo, but this is a game changer! Congrats to the DEV team and thanks Guy in a Cube 👌🙌

[sarcasticplastic]

Hi Adam, you have no idea how much this video has saved my life!!!! 🙂

[DanielOtykier]

Great video. Bravo is awesome! Btw. nice t-shirt, inyalowda.

[logato]

This is going to save so much time and effort. Our team just took over a few datasets from another team that was doing their own thing. One has 9 different dates in the main data table, and then each of those dates has an additional 8 columns for day, week, month, quarter, year, year month, year quarter, day of year. In addition, Auto date/time was turned on... Performance is terrible.

Deleting all of these columns is going to feel so good.

[martinbubenheimer]

Bravo is an amazing tool! But I didn't get the benefits of a date table clearly from your explanation. Maybe there is some technical consens among IT people to prefer a date table. But for business people the chart shown around 2:22 correctly answers the question: When were the orders placed that we shipped in March? Now with your date table solution, the slicer implicitly changes roles between order date and ship date, depending on what measure you look at. For me, this doesn't reduce confusion, it increases confusion. Plus the business people can't get an answer to the question above anymore.

[shashipaul]

That's amazing Adam That's (Bravo) new for me Great way to create calender table indeed ....Guy in a cube channel always comes with something new n interesting Thank you so much for making easy for us...

[emilymorrison]

Yes I needed a calendar table that included holidays. Great solution

[npc]

Newbie here still Learning your channel is 🔥 by the way is this what I would use if I want to take two columns that have start date and end date but I need to have a a column that determines the total years. Currently someone set it up as a measure but I don’t think you can use the measure bc when you use filters it’s showing balance when filtering to zero! Actually I have one date column but I need to calculate from that date column how many years as of today but what if some of the dates are blank?

[ACTopo]

This saved me from countless wasted hours... My friend - I thank you.

[BaldBookTuber]

This is awesome. I've been meaning to try Bravo, but was reluctant to do so for some reason. Now, I can't wait to get back to work and clean up my time intelligence within a couple of the models I've built for my org. Keep up the great work!

[skywalknotpossible]

great video, and Bravo can probably speed things up, however, doing that Interval still has to do the calculations -> increased load on the capacity. but great explanation of the concepts. (even without Bravo)

[scramiro]

Nice!!! I'll use it after Easter break 😬