Channel: Guy in a Cube

Category: Science & Technology

Tags: power bi demopower bi tutorialpower bipower bi desktoppower bi probusiness analyticspower bi hybrid tablespower bi tutorial for beginnersbusiness intelligencewhat is power bipower bi for beginnerslearn power bipower bi incremental refreshintroduction to power bipower bi tabular editorpower bi trainingtabular editor

Description: Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! --This Year let Source = Sql.Databases("servername"), AdventureWorksDW = Source{[Name="databasename"]}[Data], internetsales = AdventureWorksDW{[Schema="dbo",Item="pbi_InternetSales"]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear --Last Year let Source = Sql.Databases("servername"), AdventureWorksDW = Source{[Name="databasename"]}[Data], internetsales = AdventureWorksDW{[Schema="dbo",Item="pbi_InternetSales"]}[Data], lastyear = Table.SelectRows(internetsales, each Date.IsInPreviousYear([OrderDate])) in lastyear 📢 Become a member: guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: guyinacu.be/courses ******************* LET'S CONNECT! ******************* -- twitter.com/guyinacube -- twitter.com/awsaxton -- twitter.com/patrickdba -- facebook.com/guyinacube -- instagram.com/guyinacube -- guyinacube.com ***Gear*** 🛠 Check out my Tools page - guyinacube.com/tools #PowerBI #HybridTables #GuyInACube