Power BI date table create using DAX
Free
10 minutes
English

Provided by

Youtube is a video-sharing platform that offers a wide variety of educational content, including lectures, tutorials, and courses on a wide range of subjects....

Description

The subject of this content revolves around utilizing DAX functions within Power BI to create a comprehensive date table. It explains that automatically generated date hierarchies (year, quarter, month, day) can become limited for more complex analyses. Furthermore, it highlights the issue of hidden tables being created under the hood for each date field in the model, which could potentially overwhelm larger models. The video discusses two DAX functions used to create custom date tables: one that generates a calendar table and another that enables users to define their own custom calendars. It explores how to access these functions within Power BI's modeling area, create a new table named 'dates,' and use the 'calendar' function to generate dates based on specific criteria. The content also touches upon alternative methods of obtaining date tables from existing data warehouses or creating custom date tables that may not align with standard fiscal calendars. learn more

Professions

SQL Developer Reporting Specialist Power BI Developer Operations Researcher Market Research Analyst Financial Analyst Data Scientist Data Engineer Data Architect Data Analyst Business Analyst BI Developer Analyst

More courses by YouTube

Cookie preferences

This website uses the following types of cookies: strictly necessary, functional, and visitor statistics cookies.