Just a reminder that Alberto Ferrari will be presenting on DAX calculation groups at the Nashville Modern Excel and Power BI User Group on Thursday, December 10 at 11:30 AM CST. It's online, free, and open to the public. Be sure to sign up!
Leo Furlong at BlueGranite has Part 2 of an interesting series on Databricks in Azure. Notice the part about SQL On-Demand for serverless compute over a data lake.
Adding service principals to Power BI is way easier now than it used to be. Adam Saxton shows you how.
Reid Havens shows off the new anomaly detection visual in Power BI.
Adam Saxton has some great Power BI beginner suggestions:
Star schema all the things
Only bring in data that you need
Use DirectQuery wisely…if at all
Use variables in your DAX
If you’ve ever needed to sort by more than 1 column in RANKX in Power BI, Alberto Ferrari shows you how.
Reid Havens has a really neat way to have dynamic date-related columns headers in your Power BI reports, like “Current Month Remaining (Nov, 2020)” or “FM 1 (Dec, 2020)”. Give it a gander. Give it a try.
If you’ve wanted a primer on the new Visual Data Prep in Power BI Dataflows, Patrick LeBlanc walks you through it.