The Power BI Challenges have been the best learning experience for our Enterprise DNA members and even for non-members who join our challenges. Our aim is to bring you great scenarios and data problems which would resonate with an industry Continue reading “Emergency Services Analytics – Power BI Challenge #14 Has Launched!”
Category: Excel
How To Extract Record Field Values From Lists
For today’s video, I’d like to demonstrate how you can extract record field values from nested lists and combine those into a single text string.
Melissa
***** Video Details *****
00:00 Introduction
00:25 The problem
01:13 Reference source query
01:22 Create custom column
01:36 List.Transform
02:28 lookupvalue
04:09 Text.Combine
***** Continue reading “How To Extract Record Field Values From Lists”
Introduction to Enterprise DNA Power BI Accelerator
We’re happy to announce that we’re rolling out a new initiative within the Enterprise DNA community — the Power BI Accelerator! One of the things we’ve learned, both through research and experience, is that while you can learn a lot by Continue reading “Introduction to Enterprise DNA Power BI Accelerator”
Top 5 Tips & Tricks For Debugging Virtual Tables In Power BI
Virtual tables are my personal favorite DAX topic because I think they’re the key to unlocking the full power of DAX. Virtual tables are the only type of tables within Power BI that are fully dynamic, and there are problems Continue reading “Top 5 Tips & Tricks For Debugging Virtual Tables In Power BI”
Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to calculate Moving Annual Total in Excel worksheet with the SUMIFS function.
Topics:
1. (00:00) Introduction.
2. (00:26) Painter excelisfun Intro.
3. (00:50) SUMIFS & EOMONTH function solution solution. Works in any version of Excel.
4. (02:27) Continue reading “Moving Annual Total with SUMIFS Function. Excel Magic Trick 1724”
Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to use Conditional Format your spilled array formula so that if the formula spills new values, the formatting spills also!
Topics:
1. (00:00) Introduction
2. (00:25) Formula #1. Logical Formula that uses NOT Operator and Continue reading “Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723”
Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Using Microsoft 365 Excel, learn how to use Excel formulas to create formula number incrementors to show 1,1,1,2,2,2,3,3,3… or 1,2,3,1,2,3,12,3,… using the SEQUENCE, INT and MOD functions.
Method for Any Version of Excel: <a href="https://www.youtube.com/watch?v=AIQbJAPMrEg" Continue reading “Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722”
Power Query Makes Life Easy! Add Numbers from Description in 4 Clicks! EMT 1721 part 2
Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Learn how to add the text numbers at the end of a description to get a Sales Total using Power Query User Interface. This trick comes from YouTuber Excel Teammates Peets and Software Train.
New Look For Excel Ribbon And QAT – 2414
Microsoft is releasing a new look for the Excel Quick Access Toolbar and Ribbon. The feature is rolling out slowly to beta Insiders now. Here is a first look at the QAT and Ribbon.
Sort One Column Challenge In Excel – 2413
A question from Quora: Can you sort one column in an Excel table using the Filters and not sort the other columns? This would be easy if it was a range. But it you press Ctrl+T, I am not sure Continue reading “Sort One Column Challenge In Excel – 2413”
UNIQUE of Rectangular Range Using MAKEARRAY in Excel – 2416
Another new LAMBDA helper function in Excel is MAKEARRAY. This video shows a simple example, and then tackles the problem from episode 2317 of how to unwind a rectangular range into a single column so you can pass it to Continue reading “UNIQUE of Rectangular Range Using MAKEARRAY in Excel – 2416”
PRODUCTIF With MAP REDUCE or SCAN – 2416
Three more of the new Lambda Helper functions in Excel: MAP, REDUCE, and SCAN. In today’s episode, see three different ways to create a PRODUCTIF function in Excel using MAP, REDUCE, or SCAN.
Important points:
MAP can take one or more arrays.
MAP Continue reading “PRODUCTIF With MAP REDUCE or SCAN – 2416”