### MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships

pdf notes for Video: http://bit.ly/2KicfXm

In this video learn about how add total units from a Fact Table with Book ID. See two formulas: Total Units for each Book ID, but then also Total Units for Each Author when each book may have multiple Authors, in a Many-To-Many Relationship. Learn about the Plus Math Operator for OR Logical Test. See the IF Function to lookup correct Book IDs based on OR Logical Test.
Topics:
1. (00:15) Introduction
2. (01:12) Many-To-Many Relationships. What is a Many To Many Relationship?
3. (02:34) Worksheet Formulas and caveats
4. (03:22) SUMIFS, INDEX and MATCH Worksheet Functions to create a Total Units for Book ID Report.
5. (06:01) SUMIFS, INDEX, MATCH, IF and SUMIFS Worksheet Functions in an OR Logical Test Calculation to help simulate a Many-To-Many Relationship with the goal of creating to create a Total Units for each Author Report.
6. (08:05) OR Logical Test
7. (12:52) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

### DAX Fridays! #129: New functionality for ALLSELECTED

In the Power BI desktop update for May 2019, the ALLSELECTED fucntion functionality has been updated and in this video we discuss the changes.

The previous functionality was discussed here:
http://bit.ly/2KeNcEQ

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
http://bit.ly/2V15a0p

☼☼☼☼☼☼☼☼☼☼

Website: http://www.curbal.com

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

http://bit.ly/2V3o0Ux

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://amzn.to/2YRfIBm

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:

#daxfridays #curbal #dax #powerbi #mvp

### [Free Excel Course] Lesson 24 – Excel Pivot Table Overview

In this video of this Free Excel training, I will show you how to create and use Pivot Tables in Excel.

The video covers the following topics:

— Introduction to Pivot Tables
— Creating a Pivot Table
— Formatting Pivot Table
— Grouping data in Excel Pivot table
— Calculated Field/Items
–Slicers
— Pivot Charts

Pivot Tables are amazing as it allows you to quickly summarize a huge amount of data with a few clicks. Even if you’re using Excel for the first time, you can quickly get a hang of it.

In this video, I try to cover a lot about the Pivot Table. In case you want to learn more, check out all my Pivot Table tutorials here: http://bit.ly/2EI6Wgr

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners

-~-~~-~~~-~~-~-

Let’s Connect:
Pinterest ► http://bit.ly/2jWm2mZ

### Things I Have Learned – LPT Episode #1

Greetings, dear friend! Welcome to the very first installment of the “Things I Have Learned” series!  I am so excited to document and share some of the many things I am so fortunate to learn as I journey through this life.

The subject matter will vary – I consider myself a pretty well rounded person – meaning I have a wide range of interests and hobbies.  I am also quite passionate about my work and continuing to grow in that capacity, so naturally some of the LPT (Life Pro Tip) items I share may be technical in nature. Some of what I share may be silly as I’m known for being a bit of a comedian at times. 🙂

I hope that the items I share help you, and I would love to hear feedback from you.  Also, if you have something you would like to share with other readers, please don’t hesitate!

Without further ado, behold this first installment!

Lightning/Storms

If you’re ever caught outside in a thunderstorm and you suddenly feel your hair stand on end, squat as low to the ground on the balls of your feet as possible. Place your hands over your ears and your head between your knees. Make yourself the smallest target possible and minimize your contact with the ground.  Getting struck by lightning has always been a big fear of mine (hopefully irrational)!

SaverLife

SaverLife is an awesome organization that will pay rewards to you if you meet your savings goals (as of 5/29/19).  It appears that they (“EARN”) are a non-profit and there are several useful articles related to personal finance on their website.  I signed up last year and received \$60 from them over the course of six months.  Note: This is not an affiliate offer and I have nothing to personally gain if you sign up. Just some free money and great tools/educational material surrounding budgeting and saving for the future. Check it out!

### In the head of: Marc and Dave, the Power BI cheatsheet authors

During SQL Saturday in Stockholm, i had a chance to meet Dave and Marc, the authors of the Power BI Cheat Sheet and had a chat with them. Thanks guys!
#powerbi #cheetsheet #curbal

and here is the merch for charity:
http://bit.ly/2XciHmt

Our PLAYLISTS:
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
http://bit.ly/2V15a0p

☼☼☼☼☼☼☼☼☼☼

Website: http://www.curbal.com

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

http://bit.ly/2V3o0Ux

▲▲▲▲▲▲▲▲▲▲

************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://amzn.to/2YRfIBm

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:

### Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula

Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to Average a customers last three sales (last three dates) using Excel Worksheet Formulas, Power Query M Code and a Power Pivot & Power BI DAX Measure.
Topics:
1. (00:07) Introduction
2. (00:50) Sort Method
3. (02:09) Excel Worksheet Formulas, including AGGREGATE and AVERAGEIFS functions.
4. (05:27) LARGE Function and New Excel Office 365 Calculation Engine
5. (08:15) Power Query M Code, including Table.Sort, List.Average and List.FirstN M Code functions
6. (12:46) Power Query Parameter Query with condition coming from Excel Worksheet
7. (14:05) Power Pivot & Power BI DAX Measure, including TOPN, CALCULATE and AVERAGE DAX Functions
8. (17:08) DAX Parameter from Excel Worksheet using VALUES DAX Function.
9. (18:43) Add new records to table and test formulas
10. (19:00) Fix Power Query Table.Sort bug using Dummy Insert Column
11. (20:08) Fix Power Query Table.Sort bug using Table.Sort function inside Table.Group Function
12. (22:12) Conclusion

### [Free Excel Course] Lesson 23 – Creating Dynamic Charts in Excel

In this video of this Free Excel training, I will show you how to create dynamic charts in Excel.

Dynamic charts allow you to change the chart based on user selection. For example, you can update the chart as soon as you change the scroll bar or click a button or make a selection from a drop-down list

This video covers two detailed examples of creating dynamic charts from scratch

Example 1 – Creating a dynamic chart that updates as soon as you use the scroll bar to change the year value.

Example 2 – Creating a dynamic chart that plots the data on a scatter chart based on the column you select. There is a drop-down that allows you to select which data series should be plotted on the X-axis and which should be plotted on the Y Axis

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners

-~-~~-~~~-~~-~-

Let’s Connect:
Pinterest ► http://bit.ly/2jWm2mZ

### Power BI file to analyze json file from the Performance Analyzer (part 2)

In today’s video, I am going to share a power bi file that you can use to analyze the json file that you get as an output from the Power BI Performance Analyzer.
#curbal #powerbi

Video on Part 1: https://youtu.be/UCioY5ZgBkg

Our PLAYLISTS:
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
http://bit.ly/2V15a0p

☼☼☼☼☼☼☼☼☼☼

Website: http://www.curbal.com

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

http://bit.ly/2V3o0Ux

▲▲▲▲▲▲▲▲▲▲

************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://amzn.to/2YRfIBm

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:

### DAX Fridays! #128: Highlight MAX and MIN values in Power BI

In todays video I will show you how you can reuse conditional formatting using DAX and how to calculate max and min values of a series.

#curbal #daxfridays #dax #powerbi

Keynotes:
1. Calculate Min and Max value of a series
2. Format min and max values
3. Reuse conditional formatting using DAX

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
http://bit.ly/2V15a0p

☼☼☼☼☼☼☼☼☼☼

Website: http://www.curbal.com

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

http://bit.ly/2V3o0Ux

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l

************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://amzn.to/2YRfIBm

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:

#daxfridays #curbal #dax #powerbi #mvp

### MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model

pdf notes for Video #25-26: http://bit.ly/2QgUj0v

In this video learn about how create a Data Model with Relationships and DAX Measures to compare month product budgeted amounts to actual amounts. Then calculate variances.
Topics:
1. (00:24) Introduction & look at Data Modeling Problem
2. (03:20) Data Modeling with Relationships
3. (05:15) Diagram and pictures of how Filter Context works in our Data Model
4. (07:00) DAX Measures
5. (08:35) Important Data Modeling with Hiding Columns
6. (09:10) Data Model PivotTable
7. (09:50) Attributes that can NOT slice our Report
8. (10:28) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

### MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH

pdf notes for Video #25-26: http://bit.ly/2QgUj0v

In this video learn about how create formulas to compare month product budgeted amounts to actual amounts. Then calculate variances.

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

### [Free Excel Course] Lesson 22 – 10 Advanced Excel Charting Examples

In this video of this Free Online Excel training, I will show you how to use some tricks to create advanced charts in Excel.

The following advanced charts are covered in this video:

— Multi-Category Charts
— Gauge Chart
— Thermometer Chart
— Milestone Chart
— Water Fall Chart
— Gantt Chart
— Chart with Trend Arrows in Data Labels
— Actual Vs. Target Values
— Spotting Data in a Scatter Chart in Excel
— Dynamic Target Line in Excel Bar Charts

There a lot of advanced charting technique shown in this video and you can use these to create more types of advanced charts in Excel.

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.

You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?v=UPABcYhugZk&list=PLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners

-~-~~-~~~-~~-~-

Let’s Connect: