Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
Solved! Go to Solution.
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
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
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
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |