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: https://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: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

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

#PowerBI #HybridTables #GuyInACube