For today, we’re going to continue on the topic of last Wednesday’s video wherein we dealt with a common difficult-to-handle format of stacked data and how we can use Modulo, Pivot and some cleaning functions with Power Query to transform Continue reading “How to Create And Debug Custom Functions In Power BI”
Month: February 2022
Do we need more Power BI Premium Capacity?
Capacity planning for Power BI Premium is not an exact science. How much capacity do you need? As with most things, it depends! Adam walks through some things to consider when thinking about your planning.
Premium Gen2 capacity load evaluation
<a href="https://docs.microsoft.com/power-bi/admin/service-premium-concepts" Continue reading “Do we need more Power BI Premium Capacity?”
Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too
Download Excel File: https://excelisfun.net/files/Ch04-ESA.xlsm pdf notes: https://excelisfun.net/files/Ch04-ESA.pdf
Learn about the basics of probability:
Topics:
1. (00:00) Introduction
2. (00:58) Examples of Probability
3. (02:46) What is Probability? Define Probability.
4. (05:14) Types of Probabilities
5. (06:39) Define Random Experiment
6. (06:48) Define Continue reading “Excel Statistical Analysis 16: Introduction to Probability. Power Query & Pivot Table Example too”
A little trick for SharePoint Online Images in Power BI
Using secure images in Power BI reports can be a pain! Patrick has a little trick for you to using images from SharePoint Online though. Check this out!
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power Continue reading “A little trick for SharePoint Online Images in Power BI”
How To Handle Stacked Data In Power BI
For this tutorial, Brian is going to demonstrate how you can transform messy stacked data into a more organized format. There’s quite an easy way to do this, and it’s one that is going to be incredibly useful and has Continue reading “How To Handle Stacked Data In Power BI”
Excel Doing Billions Of Calculations To Study Wordle
After my previous video showing AROSE as the best first guess in Wordle, I started doing some more cool Excel formulas to test all Wordle words. This is a long video for the weekend, mostly of me geeking out about Continue reading “Excel Doing Billions Of Calculations To Study Wordle”
Excel STOCKHISTORY Never Falls On Weekend Or Holiday – 2468
TKH is using the new STOCKHISTORY function in Excel. He is looking for stock prices from 7, 14, 30, and 60 days ago. When you are asking for a single day, the STOCKHISTORY function returns a #VALUE error if the Continue reading “Excel STOCKHISTORY Never Falls On Weekend Or Holiday – 2468”
REPLAY Power BI tips from the Pros – LIVE (Feb 12, 2022)
Join us live as we answer your questions about Power BI!
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment Continue reading “REPLAY Power BI tips from the Pros – LIVE (Feb 12, 2022)”
How To Dynamically Select Starting Period For Any Chart In Power BI
In today’s tutorial, Brian will be doing a follow up to a short series dealing with troubles and issues that you might encounter with Time Intelligence particularly on the week granularity. For this video, Brian will demonstrate how you can Continue reading “How To Dynamically Select Starting Period For Any Chart In Power BI”
Using R In Power BI – An Exploration
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
February 10th, 5pm New York (ET), 2pm Los Angeles (PT) , 10pm London (GMT)
February 11th, 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “Using R In Power BI – An Exploration”
How to get Secure Images in Power BI Reports
Struggling getting images in your Power BI Report? Don’t want to use anonymous URLs for the image? Patrick walks you through an approach to use secured images in your reports!
Show “secured” Images in Power BI
https://pbi-guy.com/2021/11/17/show-secured-images-in-power-bi/
📢 Become a Continue reading “How to get Secure Images in Power BI Reports”
How do I get my Excel users to use Power BI???
Lots of people use Excel and love it! But what about Power BI? Why not use both together? Patrick looks at how Excel users can take advantage of Power BI and may just start using that!
Start in Excel to connect Continue reading “How do I get my Excel users to use Power BI???”