Thinking you don’t need a date table in Power BI? What about Fiscal month? Patrick shows how you could potentially go about adding that without a full date table.
But really, use a central date table 😎
Do you need a date Continue reading “No Calendar Table? How to add Fiscal Month and Sort in Power BI?”
Struggling ramping up on the Power BI Premium Gen2 Metrics App? Adam walks through the app to help you install it and navigate to get the most value. Some great stuff in the latest update!
Install the Gen2 metrics app
<a href="https://docs.microsoft.com/en-us/power-bi/admin/service-premium-install-gen2-app" Continue reading “Making sense of the Power BI Premium Gen2 Metrics App”
Sometimes your data isn’t shaped the right way. Have you tried the Pivot or Unpivot methods in Power Query? They can help get your data looking the right way for your Power BI reports!
Pivot columns
https://docs.microsoft.com/en-us/power-query/pivot-columns
Unpivot columns
<a href="https://docs.microsoft.com/en-us/power-query/unpivot-column" Continue reading “To Pivot or Unpivot? That is the question!”
Already optimized your data model and still having some performance issues in Power BI? Check out Michael Kovalsky’s Report Analyzer tool to inspect your report.
Michael Kovalsky:
https://www.linkedin.com/in/michaelkovalsky/
Michael Kovalsky’s blog:
https://www.elegantbi.com/
Report Analyzer
https://www.elegantbi.com/post/reportanalyzer
📢 Become a Continue reading “Another Power BI optimization tool – Report Analyzer”
Do you need to randomly select someone from your department to win a prize? This awesome free macro from Rob Collie at PowerPivotPro.com will do the trick. Download for free from: http://mrx.cl/spinwheel20
Rob had an idea of Continue reading “Download a Free Excel Macro to Spin The Wheel – 2371”
Three ways to filter a pivot table and two of them you might not have known about. Daniel Bula asks if the trick from episode # 2359 can be used in a pivot table. Here is a great pivot table Continue reading “Excel Illegal Filter Hack – South Region Over $5K – 2372”
Duel 195 is scheduled for next Friday. For those of you who don’t want to go a week without a Dueling Excel podcast, Bill tries a reaction video to Duel 58 – Excel Sort by Formula – from December 2010.
Download Continue reading “Reaction Video To Duel 58 Sort With A Formula – 2373”
To play along, read the trivia questions and download the data set here: https://techcommunity.microsoft.com/t5/day-of-data/space-trivia/m-p/1781544
In case you have problems solving any of the trivia questions, I’ve created a video showing the answers. Jump to the section for any Continue reading “Answers to Day Of Data Space Trivia Questions”
Exploring the Microsoft/NASA Day of Data Dataset from https://techcommunity.microsoft.com/t5/day-of-data/bd-p/DayofData
Today (November 1, 2020) marks 20 continuous years of having a human on the International Space Station (ISS). For today’s video, I explore the NASA data set to see: Continue reading “Have There Really Been Someone On The ISS For The Last 20 Years – Episode 2377”
Download Excel File: https://excelisfun.net/files/EMT1709.xlsx
Learn how to list off ASCII and Unicode characters in Excel. Why? To help to understand sorting and to make useful Text Formulas. See how to make a professional Text Formula to Document Formulas Continue reading “Amazing ASCII & Unicode Characters in Excel! Excel Magic Trick #1709”
Highline College Busn 135 Winter 2021 Intro Video
Highline College Busn 210 Statistical Analysis with Excel Intro Video, Winter 2021