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”
Category: Excel

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”

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”