When we talk about data analysis in power bi creating a date table is inevitablethere are different methods to create a date table either in dax or in power queryin dax you my use either calendar function or calendarauto function to create the date tablein power query you may use a combination of listdates date and duration functions. I made the mistake of buying power pivot and power bi the excel users guide to dax power query power bi power pivot in excel 2010 2016 as the first book to learn power queries and power pivot its a good book but i found the learn to write dax to be better for me it is better at explaining the basics of how to use power pivots if i had to do over again i would buy m is for . Open power bi desktop and click get data then click web if you are using excel with power query add in installed you can find the web connector in the power query tab if you have excel 2016 click data new query from other sources from web we will use power bi desktop in this tutorial but the steps are the same in excel. The output of power query can go to either excel or power bi that is why power query is available in both of these software think of power query as a strange but super helpful combination of sql vba excel formulas and pixie dust it gives us people working with data freedom to focus on real problems than worrying about issues like. Miguel escobar excel specialist turned into bi specialist using the latest tools from microsoft for bi power bi he is the co author of m is for data monkey blogger and also youtuber of powerful excel video tricks
How it works:
1. Register Trial Account.
2. Download The Books as you like ( Personal use )