Download Excel File: https://excelisfun.net/files/EMT1754.xlsx
Learn how to create a logical formula to apply conditional formatting like a chess board or checker board.
(00:00) Introduction
(00:30) ROWS & COLUMNS functions.
(02:28) MOD function to get remainder.
(03:09) Conditional Formatting dialog box
(04:24) Summary
This video walks through COLUMNSTATISTICS() – a new, almost entirely undocumented DAX function added to Power BI in August 2021. This function can be used to quickly create metadata on every table in your data model, including a list Continue reading “The Great New Hidden DAX Function Pt. 1 – Overview”
For today’s video, I want to walk through a couple of particular reports and share some of the tips I have around how to work out and dissect how these reports were created. The reports that I will preview have Continue reading “How To Dissect Someone Else’s Power BI Report – Learn How It Works!”
Download Excel File: https://excelisfun.net/files/EMT1753.xlsx
Learn how to Insert a Colon using an Excel Formula. Use the REPLACE function and the LEN function. Convert Text Time to Time Value using a math operation.
(00:00) Introduction
(00:07) Use the REPLACE function and Continue reading “Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753”
Check out the finals of the Financial Modeling World Cup: https://www.youtube.com/watch?v=TaW8zwnOA7M
I was a host for an Excel Competition that aired live on YouTube. Besides being one of the nerdiest & geekiest things I’ve been involved in, it Continue reading “Excel Changing Formula References By Dragging The Mouse – 2427”
Likely whenever you’ve heard an explanation of how to use variables within DAX, you will have heard the phrase “variables are constants”. It seems simple on the face of it, but there’s actually a fair amount of nuance and complexity Continue reading “What Does “Variables Are Constants” Really Mean?”
In our new Tabular Editor 3: Beginner to Advanced course, you will learn how to effectively use all the capabilities of the most powerful Power BI tool ever developed – Tabular Editor 3. TE3 replaces the nearly featureless native DAX Continue reading “How To Create KPIs Using Tabular Editor 3”
Download Excel File: https://excelisfun.net/files/EMT1752.xlsx
Learn how to filter a data set by rows and column and extract the data of to the side. See the Microsoft 365 Excel solution using the FILTER function. Then see a solution that Continue reading “Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752”
For today’s video, I want to take this opportunity to showcase and appreciate some of the best Power BI reports you’ll encounter out there that really demonstrates the great capabilities of Power BI. These reports in particular are entries to Continue reading “Epic Formula 1 Reporting Applications – Some Of The Best Power BI Reports You’ll See”
In this video, Melissa is joined by Mudassir and Jarrett as we experiment on a new tutorial format for a more collaborative experience. The Enterprise DNA experts will demonstrate how they resolve and dynamically work with a mixed column width Continue reading “How To Dynamically Work With Mixed Fixed Column Width In Power BI”
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
September 2nd, 5pm New York (EDT), 2pm Los Angeles (PDT) , 10pm London (BST)
September 3rd, 7am Sydney (AEST), 9am Auckland (NZST)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “Global Power Plants Insights – Energy Analytics w/Power BI”
We’re thrilled to announce that we’ll be releasing a new course dedicated to Tabular Editor 3. The one significant strike against TE3 is that it’s currently not well documented. But with this new course, we hope that will become Continue reading “Tabular Editor 3 Deep Dive – Brand New Course”