Here is a technique to turn the Date table M code from generating a Function query into generating a Table query. Useful for developing M code because you can see the results of your changes immediately.
Date table M code: forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390
Dynamic dates for Date tables: forum.enterprisedna.co/t/creating-a-dynamic-start-enddate-for-the-date-table/6923
All the best
Melissa
#powerbi #powerquery #subscribe #enterprisedna
***** Video Details *****
2:05 Copy the M code from the M code showcase in the Enterprise DNA Forum and paste in Query editor
2:49 edit the M code to return a table instead of function
4:10 declare variables in the inner let statement
8:00 start of M code
9:07 return query to function
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Creating a Dynamic Date Query Table in Power BI: A Query Editor Tutorial - blog.enterprisedna.co/creating-a-dynamic-date-query-table-in-power-bi-a-query-editor-tutorial/
Creating A Date Table In Power BI - blog.enterprisedna.co/creating-a-date-table-in-power-bi/
Setting Up A Dynamic StartDate And EndDate For Power Query Date Tables - blog.enterprisedna.co/setting-up-a-dynamic-startdate-and-enddate-for-power-query-date-tables/?no_cache=1
***** Related Course Modules *****
Power Query Series - portal.enterprisedna.co/p/power-query-series
Advanced Data Transformations & Modeling - portal.enterprisedna.co/courses/enrolled/197328
Best Practices & Feature Reviews - portal.enterprisedna.co/courses/enrolled/303649
***** Related Support Forum Posts *****
Dynamic Date Query Table - forum.enterprisedna.co/t/dynamic-date-query-table/1030
Add Fiscal Year + Fiscal Month To Date Table Query - forum.enterprisedna.co/t/add-fiscal-year-fiscal-month-to-date-table-query/6292
How To Find Unused Tables/Queries - forum.enterprisedna.co/t/how-to-find-unused-tables-queries/4123
For more table query support queries to review see here - forum.enterprisedna.co/search?q=table%20query
- Convert The Date Table Function Into A Table Query in Power BI ( Download)
- Create Date Table In Your Power BI Model With This Incredible Trick 📅🔥 ( Download)
- Creating a simple date table in Power BI ( Download)
- DATE TABLE for Power BI using Power Query ( Download)
- How to get a DATE TABLE easily in Power BI ( Download)
- How to make the perfect CALENDAR TABLES 📅 in Power BI ( Download)
- Master Power BI: Create Your Own Easy Fiscal Year Calendar ( Download)
- 12.1 Year, Quarter, Month & Day Functions in Power BI (Power Query) | Power BI Tutorial for Beginner ( Download)
- Power BI | New Card Visual (Small Multiples) | Text Slicer | UFO Sightings Dataset | Video 12 ( Download)
- Convert Dates to Fiscal Periods with Power Query - Better than Formulas! ( Download)
- How To Create a Date Table in Power Query | POWER BI | BI Tricks ( Download)
- Generate Year Month Day Combinations in Power BI Report using Power Query Date ToText Function ( Download)
- Convert a number column into a date column in Power BI ( Download)
- Creating New Power BI Table Based on specific values of another table ( Download)
- How to Create Calendar Table using DAX in PowerBI | MI Tutorials ( Download)
