Vivek asks: After choosing from the Filter drop-down menus, how can you get a count of the unique values from just the visible rows? This video starts with a helper column to detect if each row is visible and then Continue reading “Unique Count Of Visible Rows in Excel – 2399”
Category: Excel
Bob Umlas Interpolate Using Fill Series in Excel – 2398
Bob Umlas has a new book out. https://www.mrexcel.com/products/cool-excel-shit/ While I was working on indexing and layout of the book, I learned a lot of new Excel techniques, including this cool way to interpolate values.
If you enter Continue reading “Bob Umlas Interpolate Using Fill Series in Excel – 2398”
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”
Best Practice Recommendations For Setting Up Power BI Workspaces – Deployment Tips
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”
How To Parse Text With DAX
In this video, I’m going to show how you can use Text functions and Path functions to extract certain words from a given text stream.
Antriksh
***** Video Details *****
00:00 Introduction
00:25 Data set
01:15 Virtual column
01:42 Extract first name
03:12 LEFT
03:47 Extract middle name
06:11 Continue reading “How To Parse Text With DAX”
How To Cumulatively Compare A Best Month Results To The Current Month Using DAX
In this tutorial, I’m going to show you a quite interesting technique on how you can cumulatively compare a best months results to the current month by using DAX very effectively. I personally ran into a scenario wherein I needed Continue reading “How To Cumulatively Compare A Best Month Results To The Current Month Using DAX”
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”
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”
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.
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!”
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”
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”