ExtraDRM : Design Resource Management

Power BI date table: create using DAX

Published · Updated

In this video, Adam looks at how to create a Power BI date table using DAX. The end result uses a combination of the GENERATE(), ROW() and CALENDARAUTO() DAX functions to create a calculated table resulting in a Power BI date table.

Using GENERATE and ROW instead of ADDCOLUMNS in DAX
https://www.sqlbi.com/articles/using-generate-and-row-instead-of-addcolumns-in-dax/

LET’S CONNECT!

Guy in a Cube
— https://guyinacube.com
— http://twitter.com/guyinacube
— http://www.facebook.com/guyinacube
— Snapchat – guyinacube
— https://www.instagram.com/guyinacube/

***Gear***
Check out my Tools page – https://guyinacube.com/tools/

Post Views: 1,592

Tags:

extradrmtech

Since 30 years I work on Database Architecture and data migration protocols. I am also a consultant in Web content management solutions and medias protecting solutions. I am experienced web-developer with over 10 years developing PHP/MySQL, C#, VB.Net applications ranging from simple web sites to extensive web-based business applications. Besides my work, I like to work freelance only on some wordpress projects because it is relaxing and delightful CMS for me. When not working, I like to dance salsa and swing and to have fun with my little family.

You may also like...