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”
Author: Bb
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”
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”
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 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”