In this video, Greg goes through different approaches on how you can count distinct values in Excel from more traditional way to a more modern technique.
***** Video Details *****
00:00 Introduction
00:26 Overview
01:16 Data set
01:36 Remove duplicates method
02:45 Count distinct method
04:35 Dynamic Continue reading “How To Count Count Distinct Values In Excel”
Download Excel File: https://excelisfun.net/files/EMT1779.xlsx Solution file here: https://excelisfun.net/files/EMT1779Solution.xlsx
Learn how to create a Monthly Employee Sales By Department report three different ways. Each with their own spectacular use.
Three methods for building report:
1. (00:00) Introduction
2. Continue reading “3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779”
We at Enterprise DNA do our best to cover as much topics as possible in the vast world of Power BI and data analytics. But despite the numerous content we have in our platforms, it was brought to our attention Continue reading “How To Embed And Play Videos In Your Power BI Reports”
Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm Download data import file: https://excelisfun.net/files/MonclaireGolf.xlsx
Learn about how to import Excel Data with Power Query and load the table directly to the PivotTable, then build a Discrete Probability Distribution and Continue reading “Excel Statistical Analysis 25: Import Excel data: Build PivotTable Discrete Probability Distribution”
Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about:
Topics:
1. (00:00) Introduction.
2. (00:40) Define: Random Variable.
3. (01:40) Define: Discrete and Continuous Random Variables.
4. (03:55) Define: Probability Distribution and Discrete Probability Distribution.
5. (04:36) Three ways to Continue reading “Excel Statistical Analysis 23: Discrete Probability Distributions: Terms and Definitions”
Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm
Learn how to build Discrete Probability Distributions, Expected Value and Standard Deviation with Worksheet Formulas.
Topics:
1. (00:00) Introduction
2. (00:20) Look at Data Sets from Video #6 and PivotTable Method to create Probability Distributions
3. (00:46) Example Continue reading “Excel Statistical Analysis 24: Build Discrete Probability Distributions with Worksheet Formulas”
For today’s tutorial, Jarrett is going to demonstrate how you can create a Power Automate Desktop flow using an Excel file in Sharepoint.
***** Video Details *****
00:00 Introduction
00:39 The goal
01:51 Creating a new flow
02:57 Opening Excel in Sharepoint
05:58 Running the flow
06:27 Continue reading “How To Refresh An Excel File In Sharepoint With Power Automate Desktop”
Dynamic M Parameters for SQL are here in Power BI! YES!!! Let’s revisit a Power BI solution and how we can take it to the next LEVEL using these!
LEVEL UP Power BI Conditional Drill with Paginated reports!
rel=”nofollow”>https://youtu.be/43CwBmaym8Q
Teo Lachev’s Blog:
https://prologika.com/power-bi-dynamic-m-query-parameters-reloaded/
Chris Webb’s Blog:
https://blog.crossjoin.co.uk/2022/02/20/tsql-table-valued-functions-and-dynamic-m-parameters-in-power-bi-directquery/
Documentation:
https://docs.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #PowerQuery #GuyInACube
EVENT DETAILS – https://enterprisedna.co/power-bi-challenge-winner-best-practices-march-2022-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
March 10th – 5pm New York (ET), 2pm Los Angeles (PT), 10pm London (GMT)
March 11th – 9am Sydney (AEDT), 11am Auckland (NZDT)
Where is it?
Join in from Continue reading “Environmental Data Reporting | Power BI Challenge Winner – Best Practices”
In this video, George will demonstrate how you can load sample datasets in Python. It may not seem as a particularly exciting topics but it’s definitely something important to learn. Sample datasets are not only good to practice on when Continue reading “How To Load Sample Datasets In Python”
Oops! Forgot to show how we added the Power BI Report page tooltip from our sparkline video. Well, here it is!
Add a little info to your Sparkline in Power BI
https://www.youtube.com/watch?v=NkRVaRUVO7s
📢 Become a member: https://guyinacu.be/membership Continue reading “Oops! Forgot to show this…”
Download Excel File: https://excelisfun.net/files/EMT1776.xlsx
Learn extract invoice that are past due 1 to 30 days using Power Query..
Learn how to.
1. (00:00) Introduction
2. (00:26) Bring Defined Name Parameter into Power Query with number of days.
3. (01:15) In Power Query, Continue reading “Power Query: Extract Records For Invoices 1 to 30 Days Past Due – EMT 1778”