For today’s video, I’m going to share some best practices on how I think is the best way to setup your Power BI Workspaces. What I found from conversations within the community is that there is still a lot of Continue reading “Best Practice Recommendations For Setting Up Power BI Workspaces – Deployment Tips”
Month: August 2021
How to Automate Tabular Editor 3 With Scripts To Simplify Repetitive Tasks
In today’s video, we will delve deeper into the scripting capabilities of Tabular Editor 3 – the different ways you can generate, record and use scripts within it to automate and simplify repetitive tasks within Power BI.
Brian
Links mentioned:
Tabular Editor 3 Continue reading “How to Automate Tabular Editor 3 With Scripts To Simplify Repetitive Tasks”
BMX Saturday Seattle Park Adventure: 3 Parks, 2 Kids, 3 Old Guys!
Nick Roth, Smitty, Magic, Anton and Ernest get rad at Jefferson Park, Judkins Park, Green Lake Park on Saturday, January 9, 2021.
Not Big Air. No Big Tricks. Just kids of all ages getting rad with BMX on a Saturday Morning!
Kids Continue reading “BMX Saturday Seattle Park Adventure: 3 Parks, 2 Kids, 3 Old Guys!”
Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715
Download Excel File: https://excelisfun.net/files/EMT1715-1716.xlsx
Learn three easy ways to get help instant help with Excel function arguments: 1) Hot Link to Help, 2) Keyboard to open Functions Argument dialog box (Shift + F3) or 3) Screen Tip.
Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716
Download Excel File: https://excelisfun.net/files/EMT1715-1716.xlsx
Learn how convert a column of records into a proper data set with an Excel Worksheet Formula.
Topics:
1. (00:00) Introduction to two methods.
2. (00:46) Microsoft 365 Excel Formula: INDEX, SEQUENCE and ROWS functions.
3. (02:32) Formula Continue reading “Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716”
Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717
Download Excel File: https://excelisfun.net/files/EMT1717.xlsx
Download Text File: https://excelisfun.net/files/EMT1717RecordsInColumn.txt
Learn how convert a column of records into a table using Power Query with a User Interface Method and an M Code Method.
Topics:
1. (00:00) Introduction.
2. (00:20) Coffee Introduction
3. Continue reading “Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717”
Bob Umlas AutoSum Oddity – 2403a (Updated)
Another cool discovery by Bob Umlas. Say that you need to add a Total, Average, Max, and Min to the right of a data set. The AutoSum drop-down menu in Excel offers all four features. But how can you use Continue reading “Bob Umlas AutoSum Oddity – 2403a (Updated)”
Sort Variances By Absolute Value in Excel – 2404
A question from my Columbus Indiana virtual seminar: How can we sort a data set by Absolute Value? They have columns with Forecast, Actual, and Variance. A large variance is bad, whether it is positive or negative. My solution Continue reading “Sort Variances By Absolute Value in Excel – 2404”
Default Pivot Table Style in Excel – 2405
Another question from Columbus, Indiana. How can you choose a default style (from the PivotTable Design tab) for all future pivot tables? Yes, there is a Set as Default choice, but it only applies to future pivot tables in this Continue reading “Default Pivot Table Style in Excel – 2405”
Custom Lists To Fill Excel Data – With Ann K. Emery – 2406
I recently made a guest appearance in Ann K Emery’s class on data visualization. Over the course of an hour, I showed a few Excel tricks. This one, about Custom Lists was recently discussed in the YouTube comments for another Continue reading “Custom Lists To Fill Excel Data – With Ann K. Emery – 2406”
Excel TEXTJOIN And The Need For TEXTSPLIT with Ann K. Emery – 2407
More of my discussion with Ann K. Emery. This episode talks about TEXTJOIN and how it would be nice to have TEXTSPLIT. Check out Ann’s blog at https://depictdatastudio.com/blog/
More Snippets here:
(0:00) Welcome and intro
(0:30) Discussion about TEXTJOIN and Continue reading “Excel TEXTJOIN And The Need For TEXTSPLIT with Ann K. Emery – 2407”
Financial Reporting Techniques For Power BI – Complete Table Customization Tips
For today’s video, I’d like to go over a little bit of financial reporting. I’ve already created a few videos for this back in a couple of years now, so I think it’s time for an update. I want to Continue reading “Financial Reporting Techniques For Power BI – Complete Table Customization Tips”