Power BI Weekly
Issue #43 - 28th January 2020
No news at all from the Power BI blog this week*. However, a few practical blogs to highlight this week. DAX Studio - a tool that many of us use (and if you don't, you should!) - has had a new version (2.10.2) released. And if you use the DAX Formatter built into DAX Studio, or you access the same tool through the SQL BI website, you ought to know about a small change in the DAX formatting rules. Elsewhere, Erik Svenson has solved the mystery of why copying measures in Power BI Desktop doesn't always work, and Adam Saxton has described a couple of ways to sign-up for Power BI without a work email.
* Of course, about 5 minutes after I wrote this, the Power BI team published a blog. Typical. Anyway, that can wait until next week!
🛠️ Data Prep
- On the RADACAD blog, Reza Rad (@Rad_Reza) shares a number of blogs: Add or Edit Columns When Importing Data from Analysis Services into Power BI, Currency Exchange Rate Converter Power BI Function – Part 1, Currency Exchange Rate Conversion in Power BI with Live Rates – Part 2 and Currency Converter Power BI Function – Part 1
- On the Power BI community blog, Michal Dvorak (@nolockcz) explains how to Compare 2 Files Line by Line in Power Query
- Sebastian Zolg (@sebastianzolg) writes Time to Change (Data) - Track Your Personal Finance With Power BI Using Pivot and Python.
- Chandeep Chhabra (@chandeep2786) writes about Dynamic Column Selection in Power Query
- Darrin Kinney discusses SharePoint / PowerBI / Primavera P6 Integration – By Darrin Kinney
🧩 Data Modeling
- Joseph Yeates (@FthrsAnalytics) covers Creating an Income Statement with DAX in Power BI – Part 1
- Darren Gosbell (@darrengosbell) highlights that DAX Studio 2.10.2 Released
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Write Conditional Statement Using SWITCH in DAX and Power BI, writes Caution When Using Variables in DAX and Power BI and describes how to Sort a Column with a Custom Order in Power BI
- On the SQLBI blog, Marco Russo (@marcorus) describes Computing the future value of an investment based on compound growth in DAX and writes about A small change in DAX Formatter and in DAX formatting rules
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes a number of blogs: Working Out Sales Periods Using DAX in Power BI: Weekday vs. Weekend, Analyzing Average Results Per Month Using DAX In Power BI, Budgeting Analysis On Best & Worst Performers Using Power BI, Basket Analysis Example – Power BI Advanced Analytics, Power BI Custom Calendars: Calculating For Month On Month Change – 445 Calendars and Procurement Decisions Model And Analysis In Power BI
- Erik Svensen (@donsvensen) writes Copy a measure in the desktop – Why it doesnt always work – mystery solved
- Chandeep Chhabra (@chandeep2786) provides an Invoice and Payment Management Template
⚙️ Report Design and Visualizations
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Compare Period Over Period Breakdown in Power BI Using the Waterfall Chart and writes about Sentiment Colors for Gauge Visual in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about The Importance Of Creating Compelling Power BI Visualizations
- Carl de Souza (@carldesouza) describes how to Display Power BI Visualizations Using Azure AD and Liquid Tags inside Power Apps Portals
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes about No Code Custom Visuals – Webinar
⚙️ Data Exploration
- Chris Hamill (@ChrisHamill17) describes Creative Bookmarking for Tooltip Page Control
- Adam Saxton (@GuyInACube) asks Want Power BI Q&A to return BETTER RESULTS? Heres how!
- On the MSSQLTips site, Scott Murray writes about Power BI Advanced QandA
🚀 Deployment, Security and Operations
- Patrick Leblanc (@GuyInACube) describes Copy Power BI reports to other workspaces MADE EASY
- Chris Webb (@cwebb_bi) blogs about Sending Power BI Alerts To Users Via Teams Using Power Automate And Adaptive Cards
- Gilbert Quevauvilliers (@GilbertQue) writes about Additional reporting insights using the Get-PowerBIActivityEvent audit logs
🌐 General
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 133 - Get started with Power BI & Treb Gatte
- Adam Saxton (@GuyInACube) highlights an AWESOME resource for Power BI themes and much more... (Roundup | January 20, 2020) and presents Let's fix signing up for Power BI without a work email