ExcelHash participants discuss lessons learned and memorable moments.
#ExcelHash #Excel #MicrosoftExcel
Month: August 2021
Using Charticulator To Conditionally Highlight Bar Chart
In this video, I’ll share the solution I came up with for creating the highlighted Max Value and bringing in this measure into the Charticulator. This is a problem encountered by an Enterprise DNA member who was going through the Bar Continue reading “Using Charticulator To Conditionally Highlight Bar Chart”
Power Apps & Power Automate Masterclass Course Rollout
We have a couple of new course modules this month that will jump start your learning journey on Microsoft’s Power Apps and Power Automate. Join Sam and Brian as they introduce these 2 pioneer courses developed and taught by Enterprise Continue reading “Power Apps & Power Automate Masterclass Course Rollout”
Perpetual Holiday Calendar In Power BI – Problem Of The Week #12 (Power Query Solution)
You might be wondering, didn’t we create a Perpetual Holiday Calendar already? And the answer is, yes we sure did! That was eDNA’s maiden POTW DAX Challenge and now we get to do it all over again using only Power Query/M Continue reading “Perpetual Holiday Calendar In Power BI – Problem Of The Week #12 (Power Query Solution)”
Intro To Power Apps Masterclass
Our new course, Power Apps Masterclass, will jump start your learning journey on Microsoft’s Power Apps. This course is developed and taught by Enterprise DNA Expert, Henry Habib. Get a step-by-step guide that will help you create, share, and deploy applications Continue reading “Intro To Power Apps Masterclass”
IF Based On Word Count in Excel – 2388
Nas T has to convert sport names to a 4-letter abbreviation. If the sport name has one word, then use the left four characters. But, if the sport name has two words, use the left 3 letters from the first Continue reading “IF Based On Word Count in Excel – 2388”
New Cut Out People In Excel – 2389
There are now 925 poses of 41 different cutout people available in Excel, Word, and PowerPoint. Four have been cut from the cast. Nine have been made harder to find. Tips on using the new cutout people.
Solving Slugify With Recursive Lambdas In Excel – 2390
Building a SLUGIFY function in Excel using the brand new recursive LAMBDA function. This video shows how to use an Index argument to act as a loop counter in an Excel formula. Thanks to Smozgur who posted this example at Continue reading “Solving Slugify With Recursive Lambdas In Excel – 2390”
Three Ways to Reverse The Letters In An Excel Cell – 2391
Three ways to write a function to reverse the characters in a cell in Excel.
Fast Excel from Charles Williams offers a REVERSE function: https://mrx.cl/speedv4
Table of Contents
(0:00) Welcome and set up
(1:09) Using a VBA macro to reverse the Continue reading “Three Ways to Reverse The Letters In An Excel Cell – 2391”
Power Query Defaults To Bankers Rounding Featuring Celia Alves – 2392
A very detailed discussion today about how Excel rounds. We were all taught in school that 8.4 rounds to 8 and 8.5 rounds to 9. But not in Power Query.
Without letting you know, Power Query defaults to a rounding mode Continue reading “Power Query Defaults To Bankers Rounding Featuring Celia Alves – 2392”
How To Travel Back In Time Using DAX
In this video, I’ll demonstrate how you can travel back in time in Power BI with DAX, and dynamically show multiple date points in your matrix when selecting a specific current date with a chosen parameter.
Antriksh
Link mentioned in the video:
DAX Continue reading “How To Travel Back In Time Using DAX”
Controlling Totals and Subtotals In Power BI
Today, I’ll show how you can control totals and subtotals in your matrix visual in Power BI. This is a problem posted by one of our members at the Enterprise DNA forum wherein the user wants the columns to look Continue reading “Controlling Totals and Subtotals In Power BI”