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”
Category: Excel
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.
How To Simulate Dynamic Theming In Power BI Reports
In this tutorial, I’d like to demonstrate how you can simulate dynamic theming in your Power BI reports. As of May 2021, only a single theme JSON file can be used in a Power BI report and a page can Continue reading “How To Simulate Dynamic Theming In Power BI Reports”
How To Create A Power Apps Account
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 “How To Create A Power Apps Account”
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”
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”
Excel Magic Flashing Christmas Tree. Plus, BIG LET Surprise!!! Excel Magic Trick 1711
Download Excel File: https://excelisfun.net/files/EMT1711.xlsx
Happy Holidays, Online Excel Team!!!!!! –excelisfun
We Wish You a Merry Christmas by Twin Musicom is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/
Artist: http://www.twinmusicom.org/
Christmas Eve 2020 Old Guy BMX Park Fun!
Nick Roth, and Magic Get Rad at Burien and Renton Parks in Washington, December 24, 2020, Christmas Eve!
No Big Air. No Big Tricks. Just getting rad with BMX on Christmas Eve!
Washington BMX Old Guy Adventure 04.
Tom Hanks From A Lambda And Let Function In Excel – 2397
Here is a cool example of a LAMBDA function with a LET and XMATCH function. Point to two cells that contain movie names and the function will find the cast who is in common between the two movies and provides Continue reading “Tom Hanks From A Lambda And Let Function In Excel – 2397”
How to ROUND in Power Query To Match Excel – 2396
The Round menu option in Power Query does not round the same way that Excel rounds. This is a shorter video covering the same information that Excel MVP Celia Alves covered in episode 2391. In order to have Power Query Continue reading “How to ROUND in Power Query To Match Excel – 2396”
How to CEILING or FLOOR in Power Query – 2395
Excel has specialty rounding functions CEILING.MATH and FLOOR.MATH. Think of them like a ROUNDUP version of MROUND and a ROUNDDOWN version of MROUND. Why did they not call them MROUNDUP and MROUNDDOWN? That is a great question. Today, I show Continue reading “How to CEILING or FLOOR in Power Query – 2395”
How To TRUNC In Power Query 2394
If you are a fan of the INT or TRUNC functions in Excel, you might be surprised to learn that there is no built-in equivalent in Power Query’s M function language. Today’s episode shows a simple formula that you can Continue reading “How To TRUNC In Power Query 2394”