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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Add date table from one dataset to another

I can't find a straightforward answer in the documentation here.  I've created a custom date table to make some calculations easier  and have it functioning within one report and it's respective dataset.  Is there a simple way to bring in just that table to other datasets?  Also, is there a way to make it the default going forward?  It gives you the option to not use auto date/time but I don't see anywhere where you can tell it what to use instead.  Thanks!

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi  @Anonymous 

You need to re-create the date table in another dataset.

and you could create it easily as these blog:

https://radacad.com/do-you-need-a-date-dimension

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi  @Anonymous 

You need to re-create the date table in another dataset.

and you could create it easily as these blog:

https://radacad.com/do-you-need-a-date-dimension

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
edhans
Super User
Super User

No. When you bring in another dataset, it is the FULL data model, not just one table.

 

What you can do is create your default date table, as well as any other preferences (theme, font sizes, whatever) then save the file as a PBIT file, which is a template. Then once you start working, start with that file.

 

I've done this with my date table so I only have to make a few adjustments and start working. Creating a Dynamic Date Table in Power Query 

 

You can create a date table using DAX, but if you make changes, you cannot easily copy those changes to other files. By doing it in Power Query, I just go to the Advanced Editor and copy all of the M code to a different file. That is but one of the reasons to do the date table in power Query.


Calculated Columns vs Measures in DAX
Calculated Columns and Measures in DAX
Storage differences between calculated columns and calculated tables



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors