In this Video (Part 2 of the Date Table Series) you are going to learn how to create a Date Table (with "DAX") in Power Pivot and in Power BI. You will notice that whereas the final Date Table is "created" by DAX, all you need to know are a couple of commands.
This tutorial was made using Excel 365 and Power BI Desktop (June 2021). Keep in mind that for Excel 2010 Power Pivot is a separate AddInn you have to install.
Links to other parts of the Date Table Series:
Part 1: What is a Date (Calendar) Table and how to create one in Excel: bit.ly/2TTuABk
Part 2: Create a Date Table in Power Pivot or Power BI: this video
Part 3: Create a Date Table with Power Query in Excel or Power BI:bit.ly/3xuxDh8
Part 4: Extending the Date Table - Why you NEED to do it: bit.ly/2WRy20p
Part 5: Extending the Date Table with DAX in Power Pivot or Power BI: bit.ly/3CsQm0q
Part 6: Extending the Date Table with Power Query in Excel or Power BI: bit.ly/3hGQKj3
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the Video
1:01 Creating a Date Table in Power Pivot
8:08 Creating a Date Table in Power BI
13:35 Spoilers for next videos
14:11 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - amzn.to/3dgM8wS
Laptop: Dell XPS 15 - amzn.to/3w8CyoK
Lights: Elgato Key Light - amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - amzn.to/3amDRXP
Laptop: Dell XPS 15 - amzn.to/3effMmT
Lights: Elgato Key Light - amzn.to/3vcs6v9
Green Screen (visible in bloopers): amzn.to/3ajUm6Y
Recorded With: Camtasia - www.techsmith....
Subscribe for more Excel tutorials on the Excel Olympics RU-vid Channel: bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: bit.ly/3w3rkjK
Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek
17 авг 2024