We noticed it first on April 20, 2021… the Get & Transform Data group’s “From Table/Range” changed to “From Sheet”. Hover over the tooltip, and you will discover that they now support arrays!
This is great news. Power Query is the Continue reading “Excel Power Query Adds Support For Dynamic Arrays – 2400”
If you have a consumer edition of Microsoft 365 (personal or family), check out the new Wolfram Data Types which are reaching general availability. In this video, I show you how to navigate the Card for a cell with a Continue reading “Wolfram Data Types Reach Consumer General Availability – 2401”
New in Excel for Microsoft 365: Hold down Ctrl and Shift while scrolling the wheel mouse to scroll sideways.
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”
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”
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”
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”
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!”
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.
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/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”
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”