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/

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 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 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 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”