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”
Month: August 2021
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”
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”
Emergency Services Analytics – Power BI Challenge #14 Has Launched!
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!”
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.
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”
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”
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”
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”
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.
Excel First Look At Lambda Helper ByRow And By Col 2415
A first look at the new Excel functions BYROL and BYCOL. These functions, released to Insiders Fast this week are designed to be used with LAMBDA functions.
Read more about the 7 functions here:
https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-helper-functions-lambdas-as-arguments-and-more/bc-p/2587253#M2240
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”