Category: Life

Use Power BI without a mouse

Posted on by Annie D

In this video I will show you how you can easily click around in Power BI without using a mouse!! Now you can work in your back yard or pool side like a pro!

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

View on YouTube

Awesome! Power Query With VLOOKUP – 2292

Posted on by Annie D

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.

View on YouTube

Introduction to Power BI course, every Thursday here on the channel

Posted on by Annie D

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

View on YouTube

XLOOKUP (Revised Version) Revealed – 2291

Posted on by Annie D

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

View on YouTube

Difference between duplicate and reference a query in Power Query

Posted on by Annie D

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

View on YouTube

Bring Excel Sheet Variable Into a DAX Measure (Measure Input From Excel Sheet) EMT 1616

Posted on by Annie D

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

View on YouTube

Bring Excel Sheet Variable Into Power Query (Query Input from Excel Sheet) – EMT 1615

Posted on by Annie D

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.

View on YouTube

DAX Fridays! #148: CONVERT and resolve variant data-type error

Posted on by Annie D

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

View on YouTube

Upcoming Enterprise DNA November 2019 Learning Summit – What You Will Learn

Posted on by Annie D

FOR MORE DETAILS CLICK HERE – https://ift.tt/2q8z6Ni

Details of what will be covered below

Session 1 – Virtual Table Exploration

– Understand what virtual tables are in Power BI
– Create dynamic data groups within formulas
– Discover advanced insights fast with DAX
– Explore the limitless possibilities with virtual tables

Session 2 – Dynamic Grouping Concepts

– Learn why you should use this analytical technique
– Discover new ways to create groups for your data
– Uncover valuable insights using these ideas
– Group various dimensions from your data model effectively

Session 3 – Ranking Insights Tips

– Learn the versatility of ranking formulas with DAX
– Understand the possibilities with ranking functions
– Delve into the nuances of these important functions
– Create unique visualisations with ranking techniques

Session 4 – Developing Enterprise Apps

– Learn how to build effective app workspaces
– Scale the Power BI online service within your teams
– Manage multiple different reports and insights effectively
– Refresh your enterprise distribution strategies for insights

View on YouTube

7 ways to kill your power bi model -Part 2

Posted on by Annie D

Oh no!! I killed my Power BI model!, but if you read datachant’s blog you already know that 🙂
I killed it in 7 different ways, did you catch them all?

In this video I will show you how to avoid killing Power BI, how is that for a halloween video??

Reference links:

Datachant/ Gil Raviv blog post part 1:https://ift.tt/2NkV5sk

Other links:
Avoid flat tables: https://www.youtube.com/watch?v=QWHE8N3AkT0
Compression in Power BI/ Vertipaq: https://www.youtube.com/watch?v=A461ktvExH0
Calculated columns vs measures: https://www.youtube.com/watch?v=SmXLgEHXSGc
Avoid bi-directional relationships: https://www.youtube.com/watch?v=IlxqDCIuarU
Implicit vs explicit: https://www.youtube.com/watch?v=A95nqPLdmRU

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

View on YouTube