Two Lookup Values for Excel Lookup? Two Examples: FILTER or INDEX? – Excel Magic Trick 1590

Download Excel File: https://ift.tt/30eo31Z
Learn how to lookup up an item based on two lookup values. See two methods: FILTER Function or INDEX Function. Learn about the join operator to join the two lookup values and to join the two lookup columns.

View on YouTube

excelisfun Flashback Friday 03: VLOOKUP & Data Validation

Download Excel File: https://ift.tt/2Mzsu3z
In this video learn How to use Defined Names, Data Validation Drop Down List and VLOOKUP to lookup a price based on a product name.
This is an excelisfun YouTube Channel Flashback Friday back to a video that I made in 2008.

View on YouTube

DAX Fridays! #137: Correlation, causation, 🍦 and sharks

In todays DAX fridays video, I will talk about correlation and causation and how you can try to prove causation once you find correlation between two variables.

Spurious correlations website: https://ift.tt/2iWovBV
Image source:https://ift.tt/2KCnqKm

Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU

Link to EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaHonN82T8I1jQT

Here you can download all the pbix files: https://ift.tt/2yGx9Ih

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU

▼▼▼▼▼▼▼▼▼▼

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:

https://ift.tt/2NrgChB

Many thanks in advance!Here you can download all the pbix files: https://ift.tt/2yGx9Ih

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– 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://ift.tt/2I8nl09

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

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#daxfridays #curbal #dax #powerbi #mvp

View on YouTube

DAX Fridays! #136: Correlation, causation, 🍦 and sharks

In todays DAX fridays video, I will talk about correlation and causation and how you can try to prove causation once you find correlation between two variables.

Spurious correlations website: https://ift.tt/2iWovBV
Image source:https://ift.tt/2KCnqKm

Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU

Link to EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaHonN82T8I1jQT

Here you can download all the pbix files: https://ift.tt/2yGx9Ih

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU

▼▼▼▼▼▼▼▼▼▼

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:

https://ift.tt/2NrgChB

Many thanks in advance!Here you can download all the pbix files: https://ift.tt/2yGx9Ih

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– 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://ift.tt/2I8nl09

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

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#daxfridays #curbal #dax #powerbi #mvp

View on YouTube

Grouping visuals in Power BI – Power BI Desktop update August 2019

In today’s video I will show you how grouping visuals work in power bi and when it doesn’t as well as 2 improvement possibilities for this feature.
#curbal #powerweek #powerbi

Power bi desktop update august 2019
Here you can download all the pbix files: https://ift.tt/2yGx9Ih

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– 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:
https://ift.tt/2NEZM2b

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU

▼▼▼▼▼▼▼▼▼▼

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:

https://ift.tt/2NrgChB

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲

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

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://ift.tt/2I8nl09

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

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

View on YouTube

Enterprise DNA Learning Summit – August 2019, Optimizing DAX Formulas

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 6: Optimizing DAX Formulas

During this session we’ll be looking at a number of ideas around improving and optimizing DAX formula that you create. Enterprise DNA has a number of best practices around setting up your measures within your model.

We’ll be covering what steps you should take if you’re finding that your formulas are working very slow. Also, it’s important to gain an understanding of what certain functions are doing when used in combination with each other, so we’ll be reviewing many ideas here as well.

• Learn to structure your formulas correctly
• Master the proper syntax and best practices for measures
• Understand why your formula is working slowly
• Learn auditing techniques to optimize your measures
• Understands more deeply how formulas are calculated

View on YouTube

Enterprise DNA Learning Summit – August 2019, Budgeting Techniques

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 5: Budgeting Techniques

During this session, we’ll be covering a number of high-level budgeting concepts when working in Power BI. These techniques are some of the more advanced modeling and formula concepts that can be utilized in Power BI.

The key in this session is understanding how important it is to structure your model correctly to then simplify the formula logic that you need to write.

• Learn to deal w/ data at different granularity
• Manage a more complex data model
• Learn how to create virtual relationships using TREATAS
• Review Actuals vs Targets overtime

View on YouTube

Power Query Running Count with Grouping & Add Index – Excel Magic Trick 1589

Download Excel File: https://ift.tt/2KJWVBK
Learn how to Create a Running Count for Product Names using the Grouping and Add Index Feature. Learn how to edit your M Code. See the Power Query functions: Table.AddColumn, Table.Group, Table.AddIndexColumn and Table.Combine. This trick is a method that can calculate more quickly than the method seen in Excel Magic Trick 1588. This trick comes from our YouTube Teammates Vida and Bill Szysz.

View on YouTube

Enterprise DNA Learning Summit – August 2019, DAX Formula Combinations

EVENT DETAILS – https://ift.tt/2OPUJOe

Session 4: DAX Formula Combinations

When looking to scale your work in Power BI, you want to understand how you can reuse DAX formula combinations throughout your model. The speed in which you can create detailed analysis is significant when you utilize these techniques.

I will be covering techniques such as cumulative totals, grouping, averaging, and more.

• How to scale your development w/ DAX
• How to quickly create compelling analysis
• Analyze trends and time-based information
• Learn to re-use similar combinations of formula

View on YouTube

#D50 Reuse and customize your Power BI service usage reports

In today’s video I am going to show you how to reuse and modify your power bi Usage reports 🙂

This trick was shared by Kasper DeJonge here: https://ift.tt/2uXB0wH and there you will find the link to Gilbert’s post too. Enjoy!

You can download the pbix files here: https://ift.tt/2yGx9Ih and then community downloads number #50.

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– 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:
https://ift.tt/2NEZM2b

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU

▼▼▼▼▼▼▼▼▼▼

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:

https://ift.tt/2NrgChB

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲

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

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://ift.tt/2I8nl09

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

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

View on YouTube