Power BI

Don't repeat yourself! In this article I will show you how to make a Power Apps navigation menu component with the same style as MS Teams.

T-Mobile, one of the largest wireless carriers in the United States, has used Power Platform to save the company over $4M USD and 97,000 hours with a single Power Apps app. In addition, with Power Automate capabilities, they improved core process efficiencies by 12x while reducing errors from 7% to 0%.

This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations

Discover the power of Power Query and transform your data with ease. Learn tips and tricks in this free beginner's guide.

There’s only one rule. Don’t break the fold! Before we start enforcing all these rules, we should start with something like a solid foundation of what does and doesn’t fold in Power Query and their SQL equivalents. Now, if you found this page and we’re like “what in the world is query folding?” read this […]

Using Merge statements? Alex shows you how that can break the fold in Power Query! He’s got you covered though and shows you a different way to approach it to make folding work! Using the UI! Alex Powers: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ https://itsnotaboutthecell.com/

Remove accents and other diacritics from text in Power Query by converting the text to a binary using the Greek code page and converting back

Welcome to the February 2023 update! This month, we’ve added TypeScript support in the developer playground sandbox, several new formatting features for reporting, and so much more. Continue reading for more details on our new features!

In this article, we look at the difference between best practices and optimizations. We also define a four-step method to tackle complex issues with dataset/report performance and design.

Is your data model turning into an unfriendly monster full of unnecessary columns and measures with long refresh time? Or after cleaning up your data model, do you find that connected reports break so you manually go through each one to find the cause? In this post I will introduce you to the first version […]

Shine Brighter Your project makes you shine but when properly documented and showcased, you shine brighter.   Power BI Data Analyst and Power Platform Developers can use GitHub too. Yes, You can! Leveraging GitHub for project documentation and showcasing is another way to get more value from your ...

Learn how to use the Power BI API to connect and analyze your many data sources in this ATA Learning tutorial!

In this blog post I describe the new DAX function, LINESTX in Power BI and test it in a brief example. With the February Power BI update, two new DAX statistics functions have been introduced: LINEST and LINESTX. The functions use the Least Squares method to calculate a straight line that best fits the data, then return a table describing the line. The data result from expressions evaluated for each row in a table.

This article compares two common techniques to filter time periods in DAX: calculation groups and many-to-many relationships. A common requirement in report

In Feb 2023 Power BI Update they introduced image width in a table formatting. SVG images can now be rectangle images like this Stars SVG.

At some of my most recent customers I've developed an efficient way to analyse & deliver more meaningful, actionable and business-impactful insight to the users. I'd like to share this with you! This is based on Power BI, so I'll talk about DAX and Power BI report design, but it could be adapted to any tool. Using the Adventure Works sample database I created a couple of examples. It reads like a DevOps User Story, which is good as it switches to being busines-driven over data-driven. Some of ou

Power BI desktop released a new version in February of 2023, this feature breaks any custom properties observed when uploading a theme file into Power BI desktop. This video show you how to use the PowerBI.tips theme generator to generate files without any errors. Use the Theme generator https://themes.powerbi.tips

Navigating through snapshots, seeing all changes between them and see all the records for those orderIds is not easy. LOOKUPVALUE can help sove the problem.

The ultimate snapshot report shows all changes between snapshots and historical records for relevant order Ids using LOOKUPVALUE

fascinating exactly what I was saying with #lowcode and generative models complementing traditional development (not just coding but in this case data…

There is no secret about this. If you do any legitimate research about Power BI (reading blogs, books or training from reliable sources), you will quickly learn that a lot of basic functionality re…

Tutorial: Create smart narrative summary visualizations in Power BI

Welcome to the February 2023 update! This month, we’ve added TypeScript support in the developer playground sandbox, several new formatting features for reporting, and so much more. Continue reading for more details on our new features!

New Accessible Themes

Discussions with clients regarding the performance of their data models in Power BI have been a frequent occurrence for me recently. The issues often involve failed refreshes, queries that run slow…

Learn how to automatically balance the balance sheet in Power BI. Bookkeeping doesn't contain PnL bookings yet? Planned figures don't add up?

Create a what-if parameter in Power BI based on end user inputted values