Calculating Weighted Average in Power BI
Learn how you can add a weighted average to your Power BI Calculations, a function that is not built into DAX.
2026-10-30
1,519 reads
Learn how you can add a weighted average to your Power BI Calculations, a function that is not built into DAX.
2026-10-30
1,519 reads
Business Intelligence Architect, Data Analyst, CPA, and author Bill Pearson continues a subseries surrounding the DAX Text Functions, and breaks out the next operational group within Text functions, the “Combine and Aggregate Functions” group, including the CONCATENATE(), CONCATENATEX, and COMBINEVALUES() functions as the focus of this Level. He identifies and examines each functional member of this “Combine and Aggregate” group, discussing for each its respective syntax, uses, and operation, while providing hands-on exposure to it in Power BI.
2026-10-28
1,201 reads
Learn how to normalize values in Power BI to allow you to compare disparate different data.
2026-10-12
1,136 reads
Diagnosing memory issues can be hard. This article shows how one administrator used custom tracking to determine whether SQL Server, SSAS, or SSRS was the issue.
2026-09-25
2,172 reads
Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently launching a set of official Fabric AI Skills and the Power BI Desktop Bridge preview feature. Together, they allow AI agents to install command-line tools, inspect a running Power BI Desktop process, update a report or model in the Power BI project format (PBIP), and reload the report so that changes appear immediately.
2026-08-28
Learn how to automate OpenStreetMap data refresh on Power Bi's Azure Maps reference layer.
2026-08-17
1,841 reads
In this tip, we’ll look at some best practices to help you get the most out of your models. We will also look the DAX formula language.
2026-08-07
Learn how to add the geometric mean in Power BI to your calculations.
2026-07-06
1,222 reads
User-defined functions (UDFs) in Power BI let you build reusable, automated tests for your semantic models — so you catch broken measures, duplicate rows, and faulty relationships before they reach your reports. This article walks through how to use UDFs alongside PQL.Assert to standardize testing across your team, and how to automate those tests with Power Automate or a Fabric Notebook.
2026-06-29
Learn how you can add a harmonic mean calculation in Power BI.
2026-06-16 (first published: 2026-06-15)
1,088 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers