Excel offers the cool MROUND function to round to the nearest 5 or 25 or any number. There is no built-in equivalent function in Power Query’s M code. However, using a formula such as =Number.Round([Number]/25,0,RoundMode.AwayFromZero)*25 you can do the same Continue reading “How To MROUND In Power Query (Workaround)”
Category: Excel
How To Create Flows From Scratch Using Power Automate
Our new Power Automate Masterclass course, will jump start your learning journey on Microsoft’s Power Automate. This course is developed and taught by Enterprise DNA Expert, Henry Habib, wherein you can discover how to add powerful workflow automation directly in Continue reading “How To Create Flows From Scratch Using Power Automate”
How We Built A Dynamic Learning Map Recommendation Application In Power BI
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”
How To Run A Scheduled Flow In Power Automate
Our new Power Automate Masterclass course, will jump start your learning journey on Microsoft’s Power Automate. This course is developed and taught by Enterprise DNA Expert, Henry Habib, wherein you can discover how to add powerful workflow automation directly in Continue reading “How To Run A Scheduled Flow In Power Automate”
How To Fix Matrix Totals In Power BI
For this tutorial, I’m going to show how you can fix matrix totals in Power BI, particularly fixing totals and subtotals if the measures you create don’t produce the right results originally. I want to tackle this problem as it Continue reading “How To Fix Matrix Totals In Power BI”
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”
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.”
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.”
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.”
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.
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 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”