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”
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”
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”
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”
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.
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!”
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”
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”
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”
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”
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)”
In this video, I’ll talk about how you can look for design inspirations for your Power BI reports. Making reports on a regular basis can be draining creatively. It’s normal to run out of ideas so I want to share Continue reading “Looking For Design Inspiration For Power BI – Advance Visualization Techniques Course Sample”