Month: September 2019

DAX Fridays! #141: How to find all DAX functions and videos quickly!

Posted on by Annie D

In today’s video, I will show you how you can find all DAX functions and tutorials quickly and also how to embed them in teams to get access to them quickly!
#curbal #powerbi

Link to mentioned resources:
MS ref guide; https://ift.tt/1rRy2co › en-us › dax › dax-function-reference
DAX Fridays glossary: https://curbal.com › blogglossary
https://ift.tt/2ZUN866

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 #dax #powerbi #mvp

View on YouTube

Discovering Advanced Insights w-Power BI – Enterprise DNA Webinar Series

Posted on by Annie D

TO DOWNLOAD RESOURCE REGISTER HERE – https://ift.tt/2I5zFxw

Workshop Session Topics:
– Advanced DAX formula techniques
– Measure Branching
– Time Intelligence calculations
– Moving Average formulas
– Cumulative Total formulas
– Visualization techniques
– and others

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

Where is it?
Join in from your laptop/desktop

How long is it?
Session will run for between 45 – 60 mins

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 harness the real analytical power behind Power BI.

View on YouTube

Review of the Power BI desktop update September 2019 – Power Week!

Posted on by Annie D

It is #powerweek so we are going to review #powerbi desktop updates for September 2019.
Which ones are your favourites? Or least favourites? Let me know 🙂 #curbal #powerbi

This is the list of the features I review:
1. New default theme on power bi
2. New capabilities on JSON theme (a more indepth video coming soon.
3. Conditional formatting available for more visuals. Learn how to conditional format here: https://www.youtube.com/watch?v=CPN2LgVRla0
4. Unpin power bi default visuals
5. Custom field types available like in excel
6. Drilldown discoverability
7. Download column profiler data from power query
8. Performance improvements
9. Install power bi desktop on remote computers.

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

▲▲▲▲▲▲▲▲▲▲

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

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

#POWERWEEK #CURBAL #SUBSCRIBE

View on YouTube

3 Easy Ways to UNHIDE ALL SHEETS in Excel (with & without VBA)

Posted on by Annie D

In this video, I will show you how to unhide worksheets in Excel (with or without VBA).

In Excel, you can hide multiple worksheets at one go but you can not unhide multiple sheets at one go. If you use the inbuilt functionality to unhide sheets, it will only unhide one sheet at a time.

However, there are a couple of methods you can use to unhide all sheets at one go in Excel.

This video covers the following methods to unhide sheets:
— Manually Unhide one sheet at a time
— Unhide all sheets using VBA code in the immediate window
— Unhide all sheets by using a VBA macro code and adding it to the quick access toolbar
— Unhide sheets using custom view option.

With VBA immediate window, you can quickly run a line of code by simply adding it in the immediate window and hitting the enter key.

Below is the line of code to use in the immediate window in the VB Editor:

For each Sheet in Thisworkbook.Sheets: Sheet.Visible=True: Next Sheet

As soon as you hit the enter key (after placing the cursor at the end of the line), it will instantly unhide all the hidden sheets.

The good thing about this is that you don’t need to save the Excel workbook as a macro-enabled workbook.

Another method is by saving a VBA macro code to unhide sheets in the personal macro workbook and then adding that code to the Quick Access Toolbar (QAT)

Doing this would allow you to work on any workbook and instantly unhide sheets with a click of a button.

Below is the VBA code to save in the personal macro workbook:

Sub UnhideAllSheets()
For Each Sheet In Sheets
Sheet.Visible = True
Next Sheet
End Sub

The third method to unhide sheets is by using custom views. You can save a custom view when all the sheets are visible and then when you have to unhide all the worksheets, you can go back to that view.

This method to unhide sheets is not suited in all situations but can be useful if you’re using custom views anyway.

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

This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.

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

#Excel #ExcelTips #ExcelTutorial

View on YouTube

Automate your work from the couch with Microsoft Flow | Couch flowing

Posted on by Annie D

I have spent my weekend couch flowing, that is making microsoft flows from my couch 😉
I asked you if you wanted to see some of the flows, so here is the first one. Hope you enjoy it! #curbal #msflow #flow

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

DAX Fridays! #140:Flat tables or models in Power BI? Which one should I choose and why?

Posted on by Annie D

Should you work with flat wide tables or create models in Power BI? In this video, I walk you through the advantages of creating models instead of flattening your tables.
#curbal #daxfridays #powerbi

Link to resources mentioned in the video:
About Vertipaq: https://www.youtube.com/playlist?list=PLDz00l_jz6zyfWLZIu8psvTESmKuVDUoG

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

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