#D49 – Add rows and columns to tables using M in power query

In this video, I am going to show you how to add column and rows to a table in power query without appending it. Simply using the M language. #powerquery #curbal #powerbi

Here you can download all the pbix file (download 49- community downloads): 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

#MAGICMONDAYS #CURBAL #POWERQUERY #POWERBI #MVP

View on YouTube

Time Based Cohort Analysis – How To Setup Your Data Model In Power BI

In this example we’re going to work through how you can create time based cohort insights within Power BI.

You need to get a number of development techniques right here to make it all work, including with the data model and also with your DAX formulas.

This is a break out session from a recent Enterprise DNA member only event.

Enjoy working through this advanced analytics example for Power BI.

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 Basics Course Trailer. Free Excel Education for the World excelisfun YouTube Learning Playlist

Join Free class from excelisfun at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
Learn Excel Basics from the world renowned Excel Educator, Mike Girvin, Microsoft Excel MVP and Highline College Professor. 25 videos, free book, Excel files and homework problems make this the #1 Free Online Excel Class in the world. This class uses the amazing new YouTube Learning Playlist structurer.

View on YouTube

Dynamically Group Receivables Based On When Cash Is Expected – Power BI Accounting

During this unique accounting focused example I’m going to showcase how you can create some incredible analysis of your receivables within your organization.

We are going to review some dynamic grouping formula techniques that I believe will amaze you in their ability to showcase information in new and interesting ways.

This scenario can also be referred to as an ‘aged trial balance’

This is also a short break out session from the financial reporting course now available at Enterprise DNA Online.

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

MSPTDA #00, Course Trailer Comprehensive Data Analysis & Business Intelligence Class from excelisfun

Join Free class from excelisfun at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1
Introductory Class Video for free YouTube Learning Class Playlist from excelisfun at YouTube. 30 Videos that teach Comprehensive Data Analysis & Business Intelligence using Microsoft Power Tools. Then 30 more references videos for all your Data Analysis needs. There are a total of 66 videos that teach basics to advanced Power Query, Excel Power Pivot, Power BI Desktop (and Online), DAX Formulas and Excel. Taught by Highline College Professor, Michael Girvin.

View on YouTube

Excel Formulas & Functions – excelisfun Flashback Friday 01 – Excel Basics

Download Excel File: https://ift.tt/2Y0QCSK
In this video learn about formulas and functions from an excelisfun YouTube video posted back in the year 2008. This is a new Friday Event at the excelisfun channel: Flashback Friday. This video is remarkable because it covers most of the basics you need for formulas such as: Formulas Basics, Functions, Excel’s Golden Rule, Number Formatting, Number Formulas and Text Formulas, all in one video! Even though this video was published in 2008, all the content in the video is what you need to know about Excel Formulas and Functions in the year 2019.

View on YouTube

DAX Fridays! #132: Dynamic TopN + Others in Power BI

I was recently asked to do a TopN + Others for a customer and in this video I will share my solution with you. #curbal #dax #daxfridays #powerbi

Link to RANX video: https://www.youtube.com/watch?v=z2qzJVeYhTY
Gerhard post: https://ift.tt/2LhhfwT

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

YouTube Learning Playlists Announcement for excelisfun, July 11, 2019

At VidCon in Anaheim, CA on July 11, 2019, YouTube Playlists were Announced as a new product. Link to join Learning Playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT This video introduces you to this new YouTube Learning Playlist product with the excelisfun YouTube Channel Data Analysis & Business Intelligence Class. Check it out and have fun learning!!!

View on YouTube

Create Unique Table Template Designs Within Power BI – Power BI & Financial Reporting

In this tutorial I will show you how you can create unique table templates for your Power BI reports.

This is a short break out session from the new Financial Reporting course available at Enterprise DNA Online.

This is a high quality visualization technique developed by Enterprise DNA.

Plenty to learn and implement during this one.

We cover the technique but also formula ideas using SWITCH/TRUE logic.

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 A Rolling Average In Power BI Using DAX

In this example I’m going to show you how you can create a dynamic rolling average in Power BI.

This is a unique formula combination that allow you to calculate an average result for any selections or context that you have inside your Power BI reports.

We dive into the AVERAGEX function during this one, which is a very useful iterating function.

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

Steps To Mastering Power BI & DAX

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

When is it?
July 10th, Wednesday – 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (GMT)
July 11th, Thursday – 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

Jump To Any Excel Sheet – 7 Methods in One Minute – Excel Magic Trick 1562

Download Excel File: https://ift.tt/2G82VCN
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
7 Methods to Jump To Any Excel Worksheet in the Excel Workbook:
1. Click with Cursor to select new Worksheet
2. Scroll Arrows to show new Worksheets without changing Active Worksheet
3. Ctrl + Left-Click Right Scroll Arrow to show Last Worksheet
4. Ctrl + Left-Click Left Scroll Arrow to show First Worksheet
5. Ctrl + PageDown to select next Worksheet to right
6. Ctrl + PageUp to select next Worksheet to left
7. Right-Click Sheet Scroll Arrows to open list of all Worksheets

View on YouTube