Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
brunozanoelo
Post Patron
Post Patron

When we should create Date Table?

Hello guys, 

In one of my PBIX, I have one Star Scheme that have only one DATE column, in this case, I´m using the parameter in PowerBI Desktop which creates one "virtual" date table for each Date column, this PowerBI @GuyInACube video explains: https://www.youtube.com/watch?v=2f7dYB1l84g

In another PBIX, I have an Star Scheme but the main table have MULTIPLES date columns, in this case, should I create one DATE TABLE manually or can I continue using the parameter? Which one is better for performance?

Plus, there´s any explanation why Date and time should be saparated?

@GuyInACube let´s check if you are online 😜

Best Regards,
Bruno

2 REPLIES 2
brunozanoelo
Post Patron
Post Patron

Hello @HarishKM , thank you for your reply.

I have read this article but what I don´t understand is this:


"However, having a calendar table gives two big advantages:
- It allows you to aggregate data by non-standard columns (think your company’s financial year, or your timesheet weeks, or the Mayan calendar!).

- It gives you access to all of the wonderful time-intelligence functions in DAX, with names like TOTALYTD and CLOSINGBALANCE. Without a calendar table these won’t work."

This is not actually true, since the video that I´ve shared explains that PowerBI do this by itself with the parameter of time intelligence marked as true.

HarishKM
Power Participant
Power Participant

@brunozanoelo Hey ,

Kindly read this article . Using a Calendar 

 

Its good read .

 

HarishKM_0-1618321931460.png

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.