Category: Power Query

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” →

Excel 14 Amazing New Functions in Excel – 2469

Posted on by Annie D

Fourteen new functions in Excel: TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, CHOOSECOLS, CHOOSEROWS, DROP, TAKE, EXPAND, TOCOL, TOROW, WRAPCOLS, WRAPROWS.

Links to Help topic for each:
TEXTSPLIT: https://support.microsoft.com/en-us/office/textsplit-function-b1ca414e-4c21-4ca0-b1b7-bdecace8a6e7
TEXTBEFORE: https://support.microsoft.com/en-us/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29
TEXTAFTER: https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4
VSTACK: https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c?ns=xlwaenduser&version=16&ui=en-us&rs=en-us&ad=us
HSTACK: Continue reading “Excel 14 Amazing New Functions in Excel – 2469” →

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???” →

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

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…” →

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)” →

F2 To Bring Selected Object Back Into View in Excel – 2471

Posted on by Annie D

Today’s question from Ken: I’ve lost a slicer. I know it is somewhere on the worksheet, but how can I find it?
Thanks to Lou Pham, we have an answer. Use Home, Find & Select, Selection Pane. Select the object. Press Continue reading “F2 To Bring Selected Object Back Into View in Excel – 2471” →

Dealing with orphaned Power BI workspaces

Posted on by Annie D

What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a PowerShell script!

Delete Group/Workspace API:
https://docs.microsoft.com/rest/api/power-bi/groups/delete-group

AddUserAsAdmin API
https://docs.microsoft.com/rest/api/power-bi/admin/groups-add-user-as-admin

Power Continue reading “Dealing with orphaned Power BI workspaces” →