How to sort multiple columns using the M Language in Power Query

In today’s video I am going to show you how to sort multiple columns at once in Power Query. #curbal #powerquery #powerbi

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

Using ALLEXCEPT To Stop Cumulative Total From Resetting – DAX Solution

In this example we will work through how to use the ALLEXCEPT function to prevent a cumulative total from resetting every time a date selection is change in a Power BI report.

This was a recent question from the Enterprise DNA Support Forum where a member had a real world use case to solve for this particular piece of analysis.

This is a great review of how ALLEXCEPT work within the CALCULATE function when using the cumulative total pattern in DAX.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Extract Date from End of Description with Excel Worksheet Formula – Excel Magic Trick 1583

Download Excel File: https://ift.tt/2MxWUmL
See how to convert a text data that is part of a description to an actual date with an Excel Worksheet Formula. See three different formulas. The formulas extract the data from a description AND convert it to an actual serial number date that Excel can understand.

View on YouTube

excelisfun Flashback Friday 02: AVERAGE with Zeroes or Blanks? Ctrl + Enter Keyboard

Download Excel File: https://ift.tt/2Mzsu3z
In this video learn about how to use the AVERAGE functions with zeroes and blanks. Also learn two great using for the keyboard Ctrl + Enter. Learn about the Go To Blanks feature also.
This is an excelisfun YouTube Channel Flashback Friday back to a video that I made in 2008.

View on YouTube

DAX Fridays! #135: Linear Regression in Power BI

In today’s video I will explain Linear Regression: what it is, how it is used and how to calculate it in Power BI.
Happy summer!
#curbal #powerbi #dax #daxfridays
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

Show Cumulative Totals Unaffected By Date Slicer Selection In Power BI

In this tutorial I run through a unique example that recently came up on the Enterprise DNA Support Forum.

This example looks to solve how to showcase cumulative total comparisons, but to only have one part of the visualization affected by a slicer selection on dates.

This is relevant if you wanted to showcase information or values versus forecasts but you wanted to be able to adjust the date range you are looking at for your actual values and leave your forecasts as they are.

We look to use a duplicate date table to solve for this scenario.

Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Extract Data From Cell with Flash Fill – Excel Magic Trick 1582

Download Excel File: https://ift.tt/2MxWUmL
Learn how to use Flash Fill to extract data from a cell like getting the person’s name from a larger set of text values.
Download Excel File: https://ift.tt/2MxWUmL
Learn how to use Flash Fill to extract data from a cell like getting the person’s name from a larger set of text values.

View on YouTube

Why Using Variables Is A Better Way To Write DAX Measures – Power BI Admin Advice

In this tutorial I run through an advanced formula and how I have used variables effectively to simplify the readability of the entire function.

I talk through why and when I decide to use variables extensively versus measure branching techniques.

In the example I’m working through the logic I included in a recent member-only event focused on project management analysis in Power BI.

Enjoy!
Sam

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

Excel Formula to Reverse First & Last Name. Better Than Power Query & Flash Fill? – EMT 1581

Download Excel File: https://ift.tt/2MxWUmL
Learn how to use a formula to Extract First & Last Name with Excel Formula from Last, First. Learn how a formula can be better than Flash Fill or Power Query. Learn about the Excel Worksheet Formulas: REPLACE, SEARCH, LEFT, LEN and RIGHT.
Related video:
Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data

View on YouTube

Differences between a Power BI Apps and Workspaces

In today’s video I am going to show you the difference between Power Bi Apps and workspaces and what do I use them for.
I also explain why I think that workspaces are too messy for the business user or data consumer.

Links to resources mentioned in the video:
The new App Navigation video:

Adam’s take on Apps vs workspaces:

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

Create A Gantt Chart In Power BI With A Matrix Visual

In this tutorial, I will work through how you can create a Gantt Chart in Power BI using the matrix visual.

This is a very unique way in Power BI to create a visualization which represents time related information.

We work through how to create the right data model. The advanced DAX formula combination and also how to use conditional formatting inside the matrix visual.

Enjoy learning about Gantt Chart in this particular tutorial.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube

How To Use Iterating Functions To Solve Total Issues In Power BI – DAX Concepts

In this example I will show you how to solve issues with your total results by using simple iterating functions like SUMX in Power BI.

This is a very good review of how context works in Power BI. This is such a key concept to master when utilizing DAX formulas.

***** Learning Power BI? *****

FREE COURSE – Ultimate Beginners Guide To Power BI – https://ift.tt/2Lmxubn

FREE COURSE – Ultimate Beginners Guide To DAX – https://ift.tt/2IJLvOv

FREE – Power BI Resources – https://ift.tt/2LiAVQj

FREE – 60 Page DAX Reference Guide Download – https://ift.tt/2IJLx95

Learn more about Enterprise DNA – https://ift.tt/2LiAWDR

Enterprise DNA Membership – https://ift.tt/2IJLxWD

View on YouTube