Download Excel File: https://excelisfun.net/files/EMT1730.xlsx
Download Excel File with Finished examples: https://excelisfun.net/files/EMT1730CompletedFormulas.xlsx
Learn how to calculate Gross Profit and Percent Gross Profit in a PivotTable with one of three methods.
Topics:
1. (00:00) Introduction.
2. (00:44) Method 1: Excel Table Continue reading “PivotTable Formulas? Calculated Field, DAX Formula or Excel Table Formula for Gross Profit? EMT 1730”
Highline College Class. Busn 135 – Business Math – Spring 2021: Introduction Video
BI 348 – Microsoft Power Tools – Spring 2021: Introduction Video
Class web site: https://people.highline.edu/mgirvin/AllClasses/348/348/Spring2021BI348.htm
Welcome to this Power BI Course!
Subtitles for course are available in: English, Spanish and Persian.
View all lessons here: https://www.youtube.com/playlist?list=PLDz00l_jz6zx0wwS5HKFz5u-dEoAuRQMW
Persian Translation by: https://www.linkedin.com/in/seyed-sajad-mousavi-54035a139
This is a live Power BI demo, Continue reading “Lesson 10: Demonstration of how Power BI works”
Welcome to this Power BI Course!
Subtitles for course are available in: English, Spanish and Persian.
View all lessons here: https://www.youtube.com/playlist?list=PLDz00l_jz6zx0wwS5HKFz5u-dEoAuRQMW
Persian Translation by: https://www.linkedin.com/in/seyed-sajad-mousavi-54035a139
We’ve gone through what Power BI Desktop Continue reading “Lesson 9: Typical Power BI Workflow – Power BI 101”
Welcome to this Power BI Course!
Subtitles for course are available in: English, Spanish and Persian.
View all lessons here: https://www.youtube.com/playlist?list=PLDz00l_jz6zx0wwS5HKFz5u-dEoAuRQMW
Persian Translation by: https://www.linkedin.com/in/seyed-sajad-mousavi-54035a139
We are going to talk about what Continue reading “Lesson 8: Power BI for the data scientist – Power BI 101”
**UPDATE**: It is not possible to refresh custom connectors on the service and, there is now a Google Analytics connector on Power BI Desktop.
Welcome to this Power BI Course!
Subtitles for course are available in: English, Continue reading “Lesson 7: Intro to Power BI for developers – Power BI 101”
For today’s tutorial, I’d like to quickly go over the drill-through function in Power BI. This can be quite a powerful way to create a compelling navigation experience for the consumers of your report. I’ll Continue reading “Understanding Drill-Through Functionality And How To Use This In Power BI”
For this tutorial, I want to showcase a couple methods on how you can create new records based on date fields using Power Query.
Melissa
***** Video Details *****
00:00 Introduction
00:45 Numeric equivalent
04:11 Setting data type
04:37 List.Dates
07:22 Date.From
07:50 Continue reading “How To Create New Records Based On Date Fields”
For today’s video, I’ll walk through a real-life scenario where you might find yourself having to quickly draw up a report with specific asks in a short lead time. This is exactly what our recently Continue reading “Solve A Real-world Analytics Challenge Within Our Power BI Accelerator”
For this tutorial, I’m going to showcase how you can extract values before each occurrence of a specific text. There are many ways to achieve that, but I thought it would be fun to show Continue reading “How To Extract Values Before A Specific Text”
Download Excel File: https://excelisfun.net/files/EMT1731.xlsx
Learn how to get stock market data for financial stocks Faster and Easier than ever using Microsoft 365 Excel:
1. (00:00) Introduction
2. (00:23) Stock Data Types. Including looking up columns Continue reading “Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731”