For today’s video. I’m going to share something that we’ve been doing internally over at Enterprise DNA. I’d like to mainly showcase a couple of things – how amazing Power BI is to build world-class, dynamic and customizable applications, as Continue reading “How We Built A Dynamic Learning Map Recommendation Application In Power BI”
Month: August 2021
Old Guy BMX Park . Lower Woodland Skate Park, Seattle January 3, 2021.
Nick Roth, and Magic get rad at Green Lake Lower Woodland Skatepark Seattle, January 3, 2021 in the pouring rain.
Rain does not stop the rad action!
Not Big Air. No Big Tricks. Just getting rad with BMX in the rain on Continue reading “Old Guy BMX Park . Lower Woodland Skate Park, Seattle January 3, 2021.”
INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.
Download Excel File: https://excelisfun.net/files/EMT1712.xlsx
Learn how create a re-usable function to append tables with an Excel Formula. This tgrick comes from Excel Online Teammate cr gr0912.
Topics:
1. (00:00) Introduction.
2. (00:30) New excelisfun introduction from Geert, the Exceleer.
3. (00:51) Online Continue reading “INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.”
Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713
Download Excel File: https://excelisfun.net/files/EMT1713.xlsx
Learn how append tables that contain a small amount of data using the following functions: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. Learn a great trick in the row_num argument of INDEX function to unwind Continue reading “Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713”
Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.
Download Excel Files: https://excelisfun.net/files/EMT1714.xlsx
https://excelisfun.net/files/EMT1714Answer.xlsx
https://excelisfun.net/files/EMT1714-ExcelCurrent.xlsx
https://excelisfun.net/files/EMT1714-ExcelCurrentAnswer.xlsx
https://excelisfun.net/files/EMT1714GradeTables.zip
3 methods to append / Combine Tables in Excel Power Query: 1) Power Query Append Feature, 2) Excel.CurrentWorkbook function to combine all Continue reading “Power Query Append / Combine Tables: 3 Amazing Methods. Excel Magic Trick #1714.”
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”
Unique Count Of Visible Rows in Excel – 2399
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”
Excel Power Query Adds Support For Dynamic Arrays – 2400
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”
Wolfram Data Types Reach Consumer General Availability – 2401
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”
Excel Scroll Sideways New Feature – 2402
New in Excel for Microsoft 365: Hold down Ctrl and Shift while scrolling the wheel mouse to scroll sideways.
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”
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”