Category: Power BI

The Each Expression In Power Query / M

Posted on by Annie D

In this video, Melissa takes a closer look at the each-expression in the Power Query / M Language. When you see “each”, the formula or expression after it will be applied to each item in a list or column. Learn how you can utilize each in your reports.

***** Video Details *****
00:00 Introduction
01:25 Source
01:32 FunctionExpression
01:55 FunctionExpression2
02:07 EachExpression
02:16 EachExpression2
02:26 AllRows

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE Continue reading “The Each Expression In Power Query / M” →

Calculating Sales Financial Year To Date In Power BI With DAX [2022 Update]

Posted on by Annie D

Sam demonstrates how to get financial year to date calculations in Power BI with DAX. A simple formula that can produce great insight fast.

***** Video Details *****
00:46 Creating Total Sales Table
02:00 Calculating Sales Year To Date
03:20 Changing Calculation To Sales Financial Year To Date
04:36 Creating A Visualisation For The Existing Calculation

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download Continue reading “Calculating Sales Financial Year To Date In Power BI With DAX [2022 Update]” →

🔴 Power BI tips from the Pros – LIVE (Sept 10, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

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

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (Sept 10, 2022) (Member Chat 2nd Half)” →

Enterprise DNA On-Demand – Our New World Class Empowerment Platform, There’s Nothing Like It!

Posted on by Annie D

We are at an exciting juncture with Enterprise DNA.

We’ve evolved and extended the features of our learning platform so extensively that we’ve come to a point where we feel like we need to start repositioning our digital platform for the future. Create some separation between what we’ve offered in the past and what we want to be as an empowerment platform and partner moving into the future.

Our new platform that we’re calling Enterprise DNA On-demand is proving to be quite the game-changer, where you get to learn Power BI and the rest of the Power Platform on-demand. Watch as Sam gives a Continue reading “Enterprise DNA On-Demand – Our New World Class Empowerment Platform, There’s Nothing Like It!” →

How To Do Multiple Exact Match Text Replacements In Power Query

Posted on by Annie D

In this tutorial, Melissa will demonstrate a method on how to perform multiple exact text match replacements. If you’ve ever had this requirement, there’s a fair chance that you’ve performed a series of replace value steps. There are multiple ways to achieve this result, but Melissa will particularly show how to use the M function Record.FieldOrDefault for this specific use case.

***** Video Details *****
00:00 Introduction
00:49 Data set
01:00 Replacements
01:39 Solution

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax Continue reading “How To Do Multiple Exact Match Text Replacements In Power Query” →

Conditional Formatting with Field Parameters in Power BI???

Posted on by Annie D

You are excited about Field Parameters in Power BI, but then realize you can’t use conditional formatting with them. What the french toast! Don’t despair! Patrick and Adam have some ways to get this working.

Matthias K. Question
https://youtu.be/ksmNfa_K8GQ?t=1011

Let report readers use field parameters to change visuals (preview)
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

Apply conditional formatting in tables and matrixes
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

📢 Become a member: https://guyinacu.be/membership

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— Continue reading “Conditional Formatting with Field Parameters in Power BI???” →

The Tale of Two Caches

Posted on by Annie D

Want to optimize performance in Power BI? Of course, you do! In order to do that, you need to understand the two caches that are at play and how they affect your optimization efforts. Marco Russo helps explain!

DAX Studio 3
https://daxstudio.org

Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto

📢 Become a member: https://guyinacu.be/membership

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: rel=”nofollow”>https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Performance #GuyInACube

Get More Productive In Power BI With These Speed Development Techniques

Posted on by Annie D

In this video, Sam is going to demonstrate what he thinks are the most efficient productivity techniques that can be readily applied in Power BI that can speed up your report development by up to 200-300%! He’ll tackle embedding custom backgrounds and using a totally customized theme.

***** Video Details *****
00:00 Introduction
01:20 Embedding a background
05:40 Custom theme

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Continue reading “Get More Productive In Power BI With These Speed Development Techniques” →

Merging your data in a modern lakehouse data warehouse

Posted on by Annie D

Learn how you can move your data through different tiers using MERGE either with pySpark or SQL in Azure Synapse Analytics. Stijn Wynants walks you through the different steps.

Stijn Wynants
https://twitter.com/SQLStijn

pyspark.sql.SparkSession.createDataFrame
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.SparkSession.createDataFrame.html

Table deletes, updates, and merges
https://docs.delta.io/latest/delta-update.html#language-python

Delta Lake Documentation
https://docs.delta.io/latest/delta-intro.html

📢 Become a member: https://guyinacu.be/membership

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

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— <a Continue reading “Merging your data in a modern lakehouse data warehouse” →

How To Quickly Add Dynamic SVG Visuals To Your Power BI Report

Posted on by Annie D

Brian shares a few tools and tricks that you can use to create excellent visualization in no time flat. In this video, he will focus on SVG visuals — these are typically difficult to create from scratch, but Brian shows how you can create these quickly and easily.

***** Video Details *****
00:00 Introduction
01:18 Data set
01:44 Data model
02:02 Monitor flag
02:24 Temperature flag
02:55 Gauge visual
04:55 Blinking dot
06:01 Flat line

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power Continue reading “How To Quickly Add Dynamic SVG Visuals To Your Power BI Report” →

Get Inspired By These Excellent Power BI Examples — Innovative Techniques And Cool Features!

Posted on by Annie D

In this video, Sam showcases some reports with innovative techniques and nifty features that have recently been added in our Power BI Showcase gallery, which we hope can give you inspiration and ideas for your next Power BI report.

These showcases are definitely some of the most ingenious reports you’ll probably encounter — they’re compelling, well-designed, show great analyses & insights, and are simply impressive!

Check out more of our Power BI Showcases here: www.enterprisedna.co/power-bi-showcase

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX Continue reading “Get Inspired By These Excellent Power BI Examples — Innovative Techniques And Cool Features!” →