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”

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”

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”

Looking For Design Inspiration For Power BI – Advance Visualization Techniques Course Sample

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”