For this video, I’d like to add another installment to my mini-series about Theming in Power BI. For this video, we’ll do a quick review of the customizations you can make by directly editing and Continue reading “Custom Theming In Power BI”
Author: Bb
Why Hiding Pages Make Your Power BI Reports More Application-Like – Power BI Design Tips
For this video, I’d like to talk about how you can make your Power BI reports look more application-like by simple hiding pages. This is a methodology that I’ve seen being used in many of Continue reading “Why Hiding Pages Make Your Power BI Reports More Application-Like – Power BI Design Tips”
Power BI Deployment: Strategy, Planning & Governance – Brand New Course
To address one of the most common requests from Enterprise DNA members to provide a straightforward, practical framework for Power BI implementation, Enterprise DNA CEO and Founder, Sam McKay has personally developed a new course Continue reading “Power BI Deployment: Strategy, Planning & Governance – Brand New Course”
Column From Examples – My Favorite Feature Within The Power Query
For today’s video, I want to share by far my favorite feature inside the Power Query editor. When I look at my data sets now, I always think of how I can expand on them, Continue reading “Column From Examples – My Favorite Feature Within The Power Query”
Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.
Download Excel File: https://excelisfun.net/files/EMT1736.xlsx
Learn how to extract an ID number between a start and end space delimiter.
Topics:
1. (00:00) Introduction
2. (00:32) Worksheet Formula with 6 functions.
3. (02:21) LET function to remove formula elements Continue reading “Extract Text Between Spaces? Formulas? LET Function? Power Query? 5 Examples! EMT 1736.”
Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data
Four video release dates:
Mon, April 12: Data Analysis Class 00: Intro to PivotTable, Power Query, Power Pivot, Power BI & Visualizations, https://youtu.be/mFusmAyagsk
Mon, April 19: Excel Data Analysis Class 01: PivotTable, Power Query, Continue reading “Free Data Analysis Class: Intro to PivotTable, Power Query, Power Pivot, Power BI & Big Data”
Average Excluding Min and Max Values -TRIMMEAN function in Excel formula
Download Excel File: https://excelisfun.net/files/EMT1744.xlsx
Learn how to calculate the average while excluding the min and max values. See how to use TRIMMEAN function to exclude a given percentage of high and low data. Continue reading “Average Excluding Min and Max Values -TRIMMEAN function in Excel formula”
Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Values
Download Excel File: https://excelisfun.net/files/EMT1745.xlsx
Learn how to create and spill random normally distributed values using the NORM.INV and Continue reading “Excel Magic Trick 1745 Part 2: Create & Spill Random Normally Distributed Values”
11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745
Download Excel File: https://excelisfun.net/files/EMT1745.xlsx
Learn how to create a random monthly sales data set with the fields: Date, Continue reading “11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745”
Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747
Download Excel File: https://excelisfun.net/files/EMT1747.xlsx
Where is the VLOOKUP or XLOOKUP function in Power Query? Learn how to perform Continue reading “Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747”
IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746
Download Excel File: https://excelisfun.net/files/EMT1746.xlsx
Learn how to create an OR Logical Test to make an aggregate calculation depending Continue reading “IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746”
OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
Download Excel File: https://excelisfun.net/files/EMT1743.xlsx
Learn about aggregate calculations with conditions and criteria. Learn about an AND Logical Test, and then see how the FILTER function can help with OR Logical Tests and advanced Continue reading “OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743”