Tag: Productivity

Excel Magic Trick 1558: SUMIFS: Year Totals from Daily Sales, YOY Change, % YOY Change

Posted on by Annie D

Download Excel File: https://ift.tt/2xnWrLb
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video learn how to create Excel Worksheet Formulas for Total sales from daily dates, YOY Change in Sales and % YOY Change in Sales. Learn about the SUMIFS Function, the DATE Function and Comparative Operators for Upper and Lower Limits when adding sales between the first of the year and the end of the year. Also see a SUMPRODUCT Array Formula that is less efficient than SUMIFS.

View on YouTube

DAX Fridays! #130: Create a custom relative date filter in Power BI

Posted on by Annie D

When the custom date filter in Power BI doesn’t do what you need, how you create your own? What if you need to do it by week? Lets find out in today’s #daxfridays video. #powerbi #dax #curbal #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

When To Use TOPN In Power BI – DAX Formula Review

Posted on by Annie D

TOPN is a great DAX function to use in Power BI when you have some internal ranking logic that you want applied to your calculation.

There are many occasions where there is a better formula combination to use than the alternative of RANKX.

There is a lot reviewed around this topic in the tutorial so 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

Effective Power BI Reporting for Analysts – Enterprise DNA Webinar Series

Posted on by Annie D

TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/30b1ET4

When is it?
July 3rd, 6pm New York (EDT), 3pm Los Angeles (PDT) , 11pm London (GMT) – July 4th, 8am Sydney (AEDT), 10am Auckland (NZST)

Where is it? Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay, Founder of Enterprise DNA – Driving an analytical movement through using Power BI!

Why should I be there?
To learn how to develop compelling dashboards within Power BI using a range of analytical and visualisation techniques

What’s it all about?
We’ll be reviewing a number of techiques specifically around reporting dashboards in Power BI. Power BI is not just a visualisation tool, it is a powerful analytical engine that can produce amazing insights so I’ll be going over how you can combine both of these crucial elements to your reporting

View on YouTube

Iterating Functions Deep Dive – SUMX, AVERAGEX, MINX, MAXX

Posted on by Annie D

In Power BI you must understand the difference between aggregating functions and iterating functions very well.

In this tutorial we’ll be diving into iterating functions including SUMX, AVERAGEX, MINX & MAXX. Well be seeing the various ways they can be used and also going into detail how results are actually calculated when using these formulas.

These are some crucial concepts in Power BI when using DAX, so certainly dive into this content in detail and start practicing when you can using these techniques.

***** 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

Keyboard Shortcut to Open Smart Tags in Excel, Word & PowerPoint (Excel Magic Trick 1557)

Posted on by Annie D

Download Excel File: https://ift.tt/2xnWrLb
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video learn how to open a Smart Tag with a Keyboard. Open the Auto Fill Options or Paste Options feature with a Keyboard.

View on YouTube

17 ways 🙈 to copy and paste in Power BI

Posted on by Annie D

In today’s video I am going to show you 17 ways (!!) to copy and paste in Power BI. Did you know all of them? Did I forget any? Looking forward your comments! #curbal #powerbi

00:47 Copy and paste single values in power query
01:23 Duplicate queries in power query
01:51 Reference queries in power query
02:19 Copy and paste M queries to notepad or another power bi file
03:04 Download data with R from Power Query: https://www.youtube.com/watch?v=56FV6x8vYyQ
03:18 Enter data in power query
03:30 Copy and paste a power query column
04:40 Copy and paste an entire table form Power Query
05:30 Copy and paste column in power pivot or data view
06:10 Copy and paste a table in power pivot or data view
07:01 Copy and paste all tables with DAX Studio: https://www.youtube.com/watch?v=-Gfgnk6R0Qw
07:35 Copy and paste a value from a visual
07:40 Copy and paste selected values from a power bi visual
07:50 Copy visuals in power BI.
08:40 Export data from a visual
09:00 Copy and paste filtered data from power pivot and data view
10:00 Copy and paste the formatting of a visual in power bi

Vote for adding copy measures in power bi here:
https://ift.tt/2KWagtb

Did you knew all of them? Have I forgot any?? Looking forward your comments!

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

Total Number Of Staff Over Time

Posted on by Annie D

In this example we are attempting to work out how many staff we have at any one time.

The technique discussed here are relevant for when you have a table with multiple dates in it and you need to run logic through that table to work out if an employee is still a staff member at any period of time.

This is also the technique to use if you want to showcase staff numbers or growth through time.

We utilise the correct relationship technique and also the ‘events in progress’ pattern to get this all to work successfully in Power BI.

***** 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

Create Column of Month End Dates in Excel – Excel Magic Trick 1556

Posted on by Annie D

Download Excel File: https://ift.tt/2xnWrLb
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video learn how to create a Column of Month End Dates in Excel using the Fill Handle, the Angry Rabbit (Crosshair Cursor), and a Auto Fill Options Smart Tag.

View on YouTube

How to Sort Data from Left to Right in Excel

Posted on by Annie D

In this video, learn how to sort data from left to right in Excel.

Mostly we get datasets that are arranged in columns (with headers in a row). This is the top to a bottom format which most of us are used to. And when you sort this data, you sort it from top to bottom.

But sometimes, you may have to work with data which is on rows (i.e., the headers are in a column). And if you want to sort this data, you will have to sort it from left to right.

In this video, I show two ways of sorting the data in Excel from left to right:
1. Using the inbuilt left to right sorting feature in Excel
2. By first copying and transposing the data, sorting it from top to bottom, and then copying and transposing it back again.

While using the inbuilt left-to-right sort feature is more convenient, a lot of people prefer transposing it as they are used to top to bottom data format.

I also cover how to create custom sorting criteria in Excel. For example, when you sort the data by region from left to right, you end up with – East, North, South, and West.

This is because the data has been sorted alphabetically.

But what if you want to sort it in the following order – East, West, North, South.

To do this, you need to create a custom sorting criteria which you can then use to sort the data (left to right or top to bottom both).

You can read more about sorting data in Excel here: https://ift.tt/2YrpKZe

-~-~~-~~~-~~-~-
Find Amazing Excel Tips & Tutorials:

FREE Online Excel Training – Video Course for Beginners


-~-~~-~~~-~~-~-

Let’s Connect:
Google+ ► https://ift.tt/2jWiOzU
Facebook ► https://ift.tt/2j9gyrO
Twitter ► https://twitter.com/TrumpExcel
Pinterest ► https://ift.tt/2jWm2mZ
Youtube Channel ► https://www.youtube.com/c/trumpexcel

View on YouTube

Excel Formula to Add Sales For Each Sales Team in Celebration of Andreas’s 1000 Excel Video EMT 1555

Posted on by Annie D

Download Excel File: https://ift.tt/2xnQEFg
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video learn how to create a Sales Team Total Sales Formula in two ways: DSUM Function or SUMPRODUCT and SUMIFS. This video is to help celebrate Andrea’s 1000 Excel Video!!! Here is Andreas Thehos YouTube Channel: https://www.youtube.com/user/AThehos
DSUM with a Criteria area set up to do an OR Logical Test.
SUMIFS and SUMPRODUCT to perform adding on an Array Calculation. See a Function Argument Array Operation in the criteria 1 argument in the SUMIFS Function.

Topics:
1. (00:01) Introduction
2. (00:23) DSUM Method
3. (02:22) SUMPRODUCT & SUMIFS Method
4. (03:21) Summary

View on YouTube

Create stunning and useful apps in Power BI

Posted on by Annie D

Have you played with the new navigation app experience in Power BI? I have done it and I love it!! In this video I create an app from start to finish, to showcase all the features! #powerbi #curbal #appnavigation

Link to shared datasets video: https://www.youtube.com/watch?v=jtO4bIIy4uc

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