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.
Tag: How to
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.
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
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
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
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
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
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.
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
#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
Enterprise DNA Learning Summit – August 2019, CALCULATE vs CALCULATETABLE
EVENT DETAILS – https://ift.tt/2OPUJOe
Session 3 – CALCULATE vs CALCULATETABLE
With CALCULATE and CALCULATETABLE you have two of the most important functions in the entire DAX language. Understanding how these two functions operate is essential to any advanced analytical work in Power BI.
During this particular session, we will be drilling into the main differences between these two DAX formulas and also when it’s appropriate to use either one inside your calculated logic.
• Understand what CALCULATE does in-depth
• Start using CALCULATE correctly
• When to use CALCULATETABLE
• The main differences between these two functions
Power Query Running Count Based on Row Condition – Excel Magic Trick 1588
COUNTIFS($A$1:A1,A1) Formula in Power Query? – Excel Magic Trick 1588
Download Excel File: https://ift.tt/2OTCWpe
Learn how to create a Power Query Custom Column Formula that has an expandable range, counts based on the row condition and is equivalent to the Excel Worksheet Formula COUNTIFS($A$1:A1,A1). See how to use the Power Query Functions Table.AddColumn and Table.SelectRows. Also see how to create Two Custom Functions so we can access the Outside Table and Inside Table in the same formula.