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
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- 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
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- 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
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- 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
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- 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
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- 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
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.