Tag: How to

The Ultimate Budget Allocation Methodology For Power BI Analysis

Posted on by Annie D

When working on budget data inside Power BI you need to solve and manage data at different granularities.

In this video I work through the ultimate formula for allocating budgets to daily results.

I also work through all individual steps in the formula so you can see how it all works in together.

Enjoy working through this one!

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

Steps To Mastering Power BI & DAX

Posted on by Annie D

TO VIEW REPLAY & DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2LINHHM

When is it?
September 4th, 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT)
September 5th, 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!

During This Free Training, You Will Learn:

– The 4 Key Pillars To Any Power BI Development
– My Top, Best Practice Tips For Building Power BI Reports
– Showcase The Power Of The DAX Formula Language
– How To Combine Analytical Techniques To Solve Problems

If you have questions regarding this training, please send it at https://ift.tt/2xDKj94

View on YouTube

Extract Customer Names, Not in Master Lists with Power Query – Excel Magic Trick 1599

Posted on by Annie D

Download Excel File: https://ift.tt/2ZxRsIb
Learn how to Compare Two Lists and extract customer names that are in List 2 that are not in List 1using Power Query. See how to use the Merge feature, and the join operation; Left-Anti Join. Also see how to extract items in both lists using a Inner Join.
Related Video:
MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples

View on YouTube

#D52 Easy and fast infographics in Power BI 📈

Posted on by Annie D

In a previous video I showed you how to create infographics using the infographic designer, in today’s video I am going to show you how to do it without using the custom visual. #powerbi #curbal #infographics

Sources mentioned in the video:
Infographic designer tutorial: https://www.youtube.com/watch?v=XwOIIuRg-EI
Laura’s post: https://ift.tt/2PL3DNm

Here you can download the pbix files: https://ift.tt/2yGx9Ih choose community downloads and then #52

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

#POWERBITIPS #CURBAL #POWERBI #MVP

View on YouTube

Extract Customer Names, Not in Master Lists with Advanced Filter – Excel Magic Trick 1598

Posted on by Annie D

Download Excel File: https://ift.tt/2ZNsHaA
Learn how to Compare Two Lists and extract customer names that are in List 2 that are not in List 1, The Master List. See the Excel Worksheet Functions: MATCH, ISNA, ISNUMBER and COUNTIFS.

View on YouTube

Delete Every Other Row or Column in Excel (using Formula or VBA)

Posted on by Bb

Today we are going to explore various ways to delete every other row or delete every other column in Excel. VBA macro code is included to help you on your way if that is the path you choose.

Additionally, we will also cover how to delete every third/fourth/fifth row or column in Excel.

To delete alternate rows, you can use a helper column and use a formula that helps you identify alternate rows. This could be done by using the ISEVEN function that checks each row number and returns TRUE if the row is even and false if it isn’t.

Once you have this, you can easily filter the rows with FALSE in the helper columns and delete these.

In case you want to delete every third row, you need to use the MOD function to identify every third row. Once you have it, you can easily filter and delete every third row or every fourth row.

I also cover a method to use a simple VBA code to delete alternate rows in Excel.

Below is that VBA CODE TO DELETE ALTERNATE ROWS:

When it comes to deleting alternate columns, you cannot filter these. You can instead sort and bring all those columns together that you want to delete.

I cover a simple method that uses the MOD function to identify alternate columns and then sort these from left-to-right to bring these together. Once you have these in one place, you can select and delete these.

And there is also a VBA code that you can use to delete alternate columns.

Below is the VBA CODE TO DELETE ALTERNATE COLUMNS

Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos – https://www.youtube.com/c/trumpexcel

You can find a lot of useful Excel resources on the following site: https://trumpexcel.com/

#Excel #ExcelTips #ExcelTutorial

View on YouTube

#D51 Regular Expressions or RegEx in Power BI

Posted on by Annie D

In today’s video, I am going to show you how to do RegEx in Power BI. #powerbi #curbal #regex

Sources mentioned in the video:
Get started with R: https://www.youtube.com/watch?v=HcTdXgWGdS8
R guide to Power BI: https://www.youtube.com/watch?v=BI8FcI_sgR0
Stringr tutorial: https://ift.tt/2MR0UQn
More tutorials on strings: https://ift.tt/2NMJsvS
Regex editor: regex101.com

Here you can download the pbix files: https://ift.tt/2yGx9Ih , community downloads, download #51

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

Revenue Forecast Techniques For Project Data – Power BI Insights w/DAX

Posted on by Annie D

When working with project data in a lot of cases, you are dealing with information in the future.

In this tutorial, we work through how you can project revenue into the future based on future project data.

I showcase how to set up the model and also what DAX formulas to utilize to run this piece of analysis.

Enjoy working through this one!

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 Extract Items from Two Lists – Excel Magic Trick 1597. Is Item NOT in List?

Posted on by Annie D

Download Excel File: https://ift.tt/2zCE5af
Learn how to create a formula to extract items in List 2 that are not in List 1. Also see second formula to extract items in both lists. Learn about the MATCH & ISNA functions for “NOT in List”. Learn about MATCH & ISNUMBER for “Is In List”. See the Office 365 FILTER Function that mekas extract values from the list easy. Also see a references to the Old School Array Formula Method for extracting items from Two Lists.

View on YouTube

Calculate Days Of Zero Stock – Inventory Management Insights w/Power BI

Posted on by Annie D

Recently we had an interesting request on the Enterprise DNA Support Forum where a member needed to workout the number of days their inventory stock levels were at 0.

The technique required to work this out was unique because of the data set up that the member had.

Some different DAX formula techniques were used to solve this.

Enjoy working through this one!

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 Compare Two Lists – Excel Magic Trick 1596. Is Item in List?

Posted on by Annie D

Download Excel File: https://ift.tt/2Hsppio
Learn how to create a formula to compare two lists. See Two Formulas. One formula to ask question “Is Item in List?”. One formula to ask the question “Is Item NOT in List?”. Learn how to use the MATCH, ISNUMBER and ISNA functions. See a bonus formula that uses the VLOOKUP Function.

View on YouTube