Tag: How to

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

MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT?

Posted on by Annie D

Download files for videos: https://ift.tt/2ZOT9ge
Class web site with individual file downloads: https://ift.tt/2XGUfwU
pdf notes for Video: https://ift.tt/2ZOT9Ng

In this video learn about how to create different types of DAX average formulas and then time them using DAX Studio.
Topics:
1. (00:15) Introduction
2. (00:38) Open Power BI Desktop File and create Matrix
3. (02:37) Create First Two DAX Average Formulas
4. (06:20) Parallel Excel Worksheet example to understand the DAX averages and what happens if there is a Blank or empty cell.
5. (7:52) DAX Studio to time formulas.
6. (12:44) Look at four other DAX average formulas and timing results.
7. (14:36 ) Conclusion
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

View on YouTube

DAX101: Introduction to filter and row context

Posted on by Annie D

Are you new to DAX and want to learn what those things called filter context and row context are? I will attempt to do just that in today’s video. Let me know how I did in the comments 🙂 #dax #powerbi #daxfridays #curbal

Happy friday!

DAX 101 playlist: https://www.youtube.com/playlist?list=PLDz00l_jz6zwdC_xdTp_QANkHYIzs1BJG&disable_polymer=true

Vertipaq playlist here:https://www.youtube.com/watch?v=b8oSgTOeYCE&list=PLDz00l_jz6zyfWLZIu8psvTESmKuVDUoG
DAX funcitons playlist here:

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 bump or slope chart in Power BI

Posted on by Annie D

Bump or slope charts are useful to sport changes between categories. There is no native bump or slope visual in Power BI, but you can create your own easily from a line chart. In this video I show you how. #curbal #power bi #bumpcharts

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

Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX

Posted on by Annie D

In this example I will show you how you can calculated the difference in days between purchases in Power BI using DAX formulas.

There is some advanced logic here using the FILTER and CALCULATE functions.

This is a great insights if you want to work out trends in customer behaviour or would like the target marketing campaigns more specifically to relevant customers.

Enjoy working through this tutorial.

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

Calculate The Occupancy Days Per Month In Power BI Using DAX

Posted on by Annie D

In this unique example, I will show you how we can dynamically show how many occupancy days per month in a matrix visual.

This is a great example of the power and simplicity of the DAX formula language. Where you can write a straight forward measure and extract some fascinating information and still be able to dynamically filter the data further to showcase varied insights seamlessly.

Enjoy working through this examples

Sam

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

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube

7 powerful 🔥 tips for Power BI

Posted on by Annie D

Ready for 7 power tips for Power BI? Did you know all 7? Do you have a tip for me?
#powerbi #curbal #7powerbitips

Thanks to Kathrin Borchert for the tips about the Blank values 🙂

Download M queries: https://www.youtube.com/watch?v=fseh56DYeLc

Download previous power bi desktop files: http://bit.ly/2x7ymZ0

Amanda’s files: http://bit.ly/2RvcMqF

Here you can download all the pbix files: http://bit.ly/2PUURaz

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:
http://bit.ly/2V15a0p

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://bit.ly/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:

http://bit.ly/2V3o0Ux

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://amzn.to/2YRfIBm

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

View on YouTube

How To Manage Multiple Date Calculations In Your Fact Tables – Advanced Power BI

Posted on by Annie D

Managing multiple dates in your fact tables in Power BI can sometimes be very confusing when starting out in Power BI.

The idea behind this tutorial is to explain the logic and techniques required to get this working correctly in Power BI.

You need to get the right relationships and then use the correct DAX formula patterns when managing multiple date calculations.

Enjoy

Sam

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

FREE COURSE – Ultimate Beginners Guide To Power BI – http://bit.ly/2SGof6C

FREE COURSE – Ultimate Beginners Guide To DAX – http://bit.ly/2AyEb3P

FREE – Power BI Resources – http://bit.ly/2C2aBn3

FREE – 60 Page DAX Reference Guide Download – http://bit.ly/2AyEc7T

Learn more about Enterprise DNA – http://bit.ly/2RacRD3

Enterprise DNA Membership – http://bit.ly/2AAqa5u

View on YouTube