Power BI

Let’s say you are building a dashboard for the Sales team and have the following requirements: Each sales person should have access to only their territory – Ok this is easy enough. We …

Shared via Flipboard

DAX generator is a component of Power BI Sidetools able to create complex DAX expressions within your model. Once you built or found the appropriate template,

Warning : this documentation may mention some features under development which will appear in short term.

#powerbi #MSPowerBI

The quick measure calculates the Pearson correlation coefficient between two measures within the category.   NAME: Correlation coefficient   DESCRIPTION: Calculate the Pearson correlation coefficient between two measures within the category   PARAMETERS: Name: Category Tooltip: The category in which...

In this article, we share an idea to reduce the friction in using Power BI, by extending the DAX language with new visual calculations. At SQLBI, we teach D

This session will help you understand evaluation context, so the next time you create a DAX measure, the result will be consistent and expected.

This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code

Learn how you can use Power BI DAX functions to get the minimum start date and maximum end date of all children tasks.

Shared via Flipboard

In one of the projects, I was working on, I received feedback saying it is hard to understand how many items they have selected in a slicer, and it is…

This article describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor. When creatin

This article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. When you execute a D

Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX that can be used in Power BI.

In this tutorial, interact with a Power BI dashboard that walks through how to do linear regression in Power BI.

Make sure to download version 1.2.0 of #reportanalyzer which has just been released! Several UI enhancements have been made as well as adding the ability...

The DAX Engine can be a complex beast but with a little understanding we can tame it to work for us. Read on to find out how...

There are two options to model many-to-many relationships using Tabular and Power BI: you can use either a regular bidirectional filter relationship, or a l

People often struggle when using conditional formatting and calculation groups. If we think how calculation groups work there's many ways to use them effectively.

If your like me, you may have gotten a little over enthusiastic about calculation groups and dropped a number of them into a report page only to find that while dense with information, the report p…

In composite models, any query can be executed on the remote model (wholesale execution) or by mixing local and remote engines together (retail execution).

When used in a composite model, calculation groups show a very unique behavior that a good DAX developer must understand well to build sound models. In this

MicrosoftHatesGregsQuickMeasures Installation How to Use NotesAn external tool for creating quick measures or columns in Power BI Desktop or tabular model. Read more about it here Microsoft Hates …

Useful code for tabular modeling and automation. Contribute to m-kovalsky/Tabular development by creating an account on GitHub.

Creating a Custom DLL for Tabular Editor C# Scripts and moving development over to Visual Studio can help you code faster c# scripts for Tabular Editor

Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic

Our Power BI Principal Consultant Kane Snyder shares a technique for optimising calculation group performance.

This article introduces the syntax to describe in a textual form the DAX expressions and additional properties of calculation groups. When calculation group