Please watch the video for a step by step walkthrough and explanation of the how to in this tutorial.<\/p>\n
In this video, we\u2019re going back to basics and I\u2019ll show you the fastest way to create a highly comprehensive data table within the Power BI Models from scratch.<\/p>\n
I\u2019ve done so many tutorials about creating date tables over the years, but this new method is by far, the most efficient way to do it. This is actually an approach developed by one of our Enterprise DNA experts, Melissa De Korte. Not only will this approach make the entire process faster, but it\u2019s also going to yield better quality results.<\/p>\n
Sam<\/p>\n
***** Video Details *****
\n00:00 Introduction
\n01:23 Create a new blank query
\n01:40 Extended Date Table code
\n03:00 Adding parameters
\n04:44 Making changes to the date table
\n05:33 Saving the data table as a template<\/p>\n
***** Learning Power BI? ***** #PowerQuery #PowerQueryTutorial #PowerBIDateTable #PowerQueryMCode #MLanguage<\/p>\n","protected":false},"excerpt":{"rendered":" In your Power BI model, click Transform Data in the menu. Click New Source, and choose Blank Query. Head over to the Enterprise DNA forum.\u00a0 \u00a0Under the M Code showcase, you will find the Extended Date Table post (https:\/\/forum.enterprisedna.co\/t\/extended-date-table-power-query-m-function\/6390) Copy the code from that post. Back in Power BI, click the Advanced Editor.\u00a0 Remove the […]<\/p>\n","protected":false},"author":3,"featured_media":3017,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[137],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2021\/12\/NAghaFGXVFE.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-ME","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/3016"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=3016"}],"version-history":[{"count":1,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/3016\/revisions"}],"predecessor-version":[{"id":3042,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/3016\/revisions\/3042"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/3017"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=3016"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=3016"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=3016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nFREE COURSE – Ultimate Beginners Guide To Power BI – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-power-bi<\/a>
\nFREE COURSE – Ultimate Beginners Guide To DAX – http:\/\/portal.enterprisedna.co\/p\/ultimate-beginners-guide-to-dax<\/a>
\nFREE – Power BI Resources – http:\/\/enterprisedna.co\/power-bi-resources<\/a>
\nFREE – 60 Page DAX Reference Guide Download – https:\/\/enterprisedna.co\/dax-formula-reference-guide-download\/<\/a>
\nEnterprise DNA Membership – https:\/\/enterprisedna.co\/membership<\/a>
\nEnterprise DNA Online – http:\/\/portal.enterprisedna.co\/<\/a>
\nEnterprise DNA Events – https:\/\/enterprisedna.co\/enterprise-dna-events-page\/<\/a><\/p>\n