Category: Power BI

Organize your DAX measures

How To Organize Your DAX Measures in Power BI Folders and Make Finding Them A Breeze

Posted on by Bb

As you progress in Power BI, you will gradually be working with more DAX measures and calculations. As a result, things can easily get cluttered. Today you will learn a few valuable tips and tricks on how to organize your DAX measures for a more efficient workflow. Hopefully this will help you and become a standard practice!

Watch the video for step by step instructions and a full explanation.

To summarize, Reid shows us how to add a new table and move our measures to it so they are together in one place.

He then shows us how to convert this into a folder, and then subsequently create subfolders to further organize your DAX measures in the model. Reid continues on to show us how we can have a measure in multiple locations if it makes sense.

What a great way to manage the measures as they grow in number!

***** Video Details *****
00:00 Introduction
00:33 Root folders
01:32 Subfolders
03:30 Actual Amount VTB

***** 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://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

Some tips for your data labels in Power BI

Posted on by Annie D

Charts can be hard to understand sometimes. Ambiguity is never a good thing. Here are some tips for using data labels in Power BI to help your consumers better understand the meaning of the values.

📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Some tips for your data labels in Power BI” →

So, we just wait???

Posted on by Annie D

What’s up with the wait time in Power BI Dataflows? Do we just live with it? What’s going on and what can we do about? Adam, has you covered!

Understanding and optimizing dataflows refresh
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh

📢 Become a member: <a Continue reading “So, we just wait???” →

How To Count Count Distinct Values In Excel

Posted on by Annie D

In this video, Greg goes through different approaches on how you can count distinct values in Excel from more traditional way to a more modern technique.

***** Video Details *****
00:00 Introduction
00:26 Overview
01:16 Data set
01:36 Remove duplicates method
02:45 Count distinct method
04:35 Dynamic Continue reading “How To Count Count Distinct Values In Excel” →

How To Refresh An Excel File In Sharepoint With Power Automate Desktop

Posted on by Annie D

For today’s tutorial, Jarrett is going to demonstrate how you can create a Power Automate Desktop flow using an Excel file in Sharepoint.

***** Video Details *****
00:00 Introduction
00:39 The goal
01:51 Creating a new flow
02:57 Opening Excel in Sharepoint
05:58 Running the flow
06:27 Continue reading “How To Refresh An Excel File In Sharepoint With Power Automate Desktop” →

Revisiting a Power BI solution with Dynamic M Parameters

Posted on by Annie D

Dynamic M Parameters for SQL are here in Power BI! YES!!! Let’s revisit a Power BI solution and how we can take it to the next LEVEL using these!

LEVEL UP Power BI Conditional Drill with Paginated reports!
rel=”nofollow”>https://youtu.be/43CwBmaym8Q

Teo Lachev’s Blog:
https://prologika.com/power-bi-dynamic-m-query-parameters-reloaded/

Chris Webb’s Blog:
https://blog.crossjoin.co.uk/2022/02/20/tsql-table-valued-functions-and-dynamic-m-parameters-in-power-bi-directquery/

Documentation:
https://docs.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters

📢 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
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

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

#PowerBI #PowerQuery #GuyInACube

Environmental Data Reporting | Power BI Challenge Winner – Best Practices

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/power-bi-challenge-winner-best-practices-march-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
March 10th – 5pm New York (ET), 2pm Los Angeles (PT), 10pm London (GMT)
March 11th – 9am Sydney (AEDT), 11am Auckland (NZDT)

Where is it?
Join in from Continue reading “Environmental Data Reporting | Power BI Challenge Winner – Best Practices” →

Oops! Forgot to show this…

Posted on by Annie D

Oops! Forgot to show how we added the Power BI Report page tooltip from our sparkline video. Well, here it is!

Add a little info to your Sparkline in Power BI
https://www.youtube.com/watch?v=NkRVaRUVO7s

📢 Become a member: https://guyinacu.be/membership Continue reading “Oops! Forgot to show this…” →

Why You Should Get Microsoft Certifications For Power Platform

Posted on by Annie D

Do you want to show your prospective employers that you know Power Platform? Are you confused by what all the different Power Platform certifications mean? Why is PL-900 easier than PL-200? In this video, Henry answers those questions and goes Continue reading “Why You Should Get Microsoft Certifications For Power Platform” →

REPLAY Power BI tips from the Pros – LIVE w/ Marco Russo (Mar 5, 2022)

Posted on by Annie D

💥 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 Continue reading “REPLAY Power BI tips from the Pros – LIVE w/ Marco Russo (Mar 5, 2022)” →