Today, recorded from #MSIgnite 2019 in Orlando – how to import a CSV file and merge that file with a VLOOKUP table on the way in. This video shows how to use Only Create a Connection in order to define a pointer to the lookup table and the CSV file. Then, a Merge query will solve the problem.
Month: November 2019
Introduction to Power BI course, every Thursday here on the channel
Inspired by the amazing work Seyed Sajjad did with the Persian translation of the course, I have decided to release it here on youtube for everybody.
Every thursday, a new video, until I have published them all.
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
#CURBAL #SUBSCRIBE
XLOOKUP (Revised Version) Revealed – 2291
Here is a look at the final version of XLOOKUP, along with 10 benefits of XLOOKUP over VLOOKUP, HLOOKUP, LOOKUP, INDEX/MATCH.
Table of Contents
(0:25) List of Benefits
(2:30) First XLOOKUP
(3:02) 3rd argument is not an integer
(3:29) Handle items not found
(3:51) Range lookup find value just less like VLOOKUP(,,,True)
(4:41) Find value just larger like MATCH – without sorting
(5:16) HLOOKUP replaced by XLOOKUP
(5:30) Search from bottom of table
(6:21) Wildcards in XLOOKUP versus VLOOKUP
(6:56) Return all 12 months from table with single formula
(7:38) XLOOKUP can return a cell reference XLOOKUP:XLOOKUP
(9:10) Two-Way Match
(10:09) Sum All lookups
(10:44) Twisted XLOOKUP
(11:13) Wrap up on XLOOKUP
(11:30) Swag at Ignite Conference
Difference between duplicate and reference a query in Power Query
In this video I am going to show you the difference between duplicate and reference a query in Power Query and what you can use them for.
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
#CURBAL #SUBSCRIBE
Bring Excel Sheet Variable Into a DAX Measure (Measure Input From Excel Sheet) EMT 1616
Download Excel Start File: https://ift.tt/2WBqJps
Download Excel Finished File: https://ift.tt/2NaqKhc
Learn how to bring an item from an Excel Cell in a DAX Formula in the Excel Power Pivot Data Model. Learn how to refresh the single Variable Query. Learn how to record a Macro and assign it to a button for easy refreshing.
Topics:
1. (00:01) Introduction
2. (00:27) Bring an item from an Excel Cell in a DAX Formula in the Excel Power Pivot Data Model.
3. (01:40) Use VALUES DAX Function to bring variable from an Excel Sheet to a DAX Measure.
4. (02:42) Build a Data Model PivotTable.
5. (03:20) Learn how to refresh the single Variable Query.
6. (03:50) Learn how to record a Macro and assign it to a button for easy refreshing.
7. (05:25) Summary
BREAKING: XLOOKUP Changes and Breaks – 2290
Today, November 3, 2019, the function arguments for XLOOKUP changed. The if_not_found argument moved from 6th to 5th. That means any old XLOOKUP functions that used arguments 4, 5, or 6 might break at the next Recalc.
Bring Excel Sheet Variable Into Power Query (Query Input from Excel Sheet) – EMT 1615
Download Excel Start File: https://ift.tt/335Q51m
Download Excel Finished File: https://ift.tt/2N8NRZB
Learn how to bring an item from an Excel Cell in an Excel Worksheet into the Power Query Editor and use it as a variable in other queries.
DAX Fridays! #148: CONVERT and resolve variant data-type error
Have you got this error in Power BI? “Expressions that yield variant data-type cannot be used to define calculated columns”. If you have, check this video to learn how to fix it using the new DAX function CONVERT.
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to DAX Fridays survey: http://bit.ly/2MMM4KK
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 #SUBSCRIBE