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”
Month: August 2021
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”
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.
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/
How To MROUND In Power Query (Workaround)
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)”
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”
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 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”
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 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 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”
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”