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.<\/p>\n
Using GENERATE and ROW instead of ADDCOLUMNS in DAX
\nhttps:\/\/www.sqlbi.com\/articles\/using-generate-and-row-instead-of-addcolumns-in-dax\/<\/p>\n
LET’S CONNECT!<\/p>\n
Guy in a Cube
\n— https:\/\/guyinacube.com
\n— http:\/\/twitter.com\/guyinacube
\n— http:\/\/www.facebook.com\/guyinacube
\n— Snapchat – guyinacube
\n— https:\/\/www.instagram.com\/guyinacube\/<\/p>\n
***Gear***
\nCheck out my Tools page – https:\/\/guyinacube.com\/tools\/<\/p>\n","protected":false},"excerpt":{"rendered":"
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...<\/p>\n","protected":false},"author":1,"featured_media":3280,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"video","meta":[],"categories":[547,583],"tags":[595,596,597,598,599],"youtube_video":{"channel_id":"UCFp1vaKzpfvoGai0vE5VJ0w","channel_title":"Guy in a Cube","title":"Power BI date table: create using DAX","description":"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.\r\n\r\nUsing GENERATE and ROW instead of ADDCOLUMNS in DAX\r\nhttps:\/\/www.sqlbi.com\/articles\/using-generate-and-row-instead-of-addcolumns-in-dax\/\r\n\r\nLET'S CONNECT!\r\n\r\nGuy in a Cube\r\n-- https:\/\/guyinacube.com\r\n-- http:\/\/twitter.com\/guyinacube\r\n-- http:\/\/www.facebook.com\/guyinacube\r\n-- Snapchat - guyinacube\r\n-- https:\/\/www.instagram.com\/guyinacube\/\r\n\r\n***Gear***\r\nCheck out my Tools page - https:\/\/guyinacube.com\/tools\/","category_id":"28","category":"Science & Technology","tags":["Business Intelligence","Business Analytics","Analytics","GuyInACube","Guy in a Cube","Microsoft","PowerBI","bi","calculated table","calendarauto","calendarauto power bi","date table","Power BI","power bi date dimension table","power bi date hierarchy","Power bi date table","power bi date table relationships","power bi dax","power bi desktop","power bi tutorial","power bi tutorial for beginners","date dimension","DAX date table","DAX"],"duration":644,"iso_duration":"PT10M44S","human_duration":"10:44","definition":"hd","thumbnails":{"default":{"url":"https:\/\/i.ytimg.com\/vi\/gyvhM5eiT0U\/default.jpg","width":120,"height":90},"medium":{"url":"https:\/\/i.ytimg.com\/vi\/gyvhM5eiT0U\/mqdefault.jpg","width":320,"height":180},"high":{"url":"https:\/\/i.ytimg.com\/vi\/gyvhM5eiT0U\/hqdefault.jpg","width":480,"height":360},"standard":{"url":"https:\/\/i.ytimg.com\/vi\/gyvhM5eiT0U\/sddefault.jpg","width":640,"height":480},"maxres":{"url":"https:\/\/i.ytimg.com\/vi\/gyvhM5eiT0U\/maxresdefault.jpg","width":1280,"height":720}},"video_id":"gyvhM5eiT0U","published":"2018-02-13T16:00:02Z","stats":{"comments":"191","views":"157091","likes":"1850","dislikes":"35","favourite":"0"},"privacy":{"status":"public","embeddable":true,"license":"youtube"}},"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3279"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3279"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3279\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/3280"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}