dax

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

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular. When you use VertiPaq Analyzer or the data management view (DMV) to get the size of the dictionary of a column (DISCOVER_STORAGE_TABLE_COLUMNS), yo

En anteriores posts vimos diferentes cálculos en DAX como por ejemplo conocer cuántos clientes habían efectuado su última compra hace 90 días, este cálculo permitía llegar a cierta segmentación de...

There are some calculation groups that you might use in almost any project you do. Here you'll find C# Scripts to create calculation groups that you should have

Do you think Microsoft's files always follow best practices? In this episode, I'm dissecting a DAX formula from an automatically generated Power BI file.

OR logic in DAX is frequently used in various Power BI calculations. The bad and the good news is that you can create that in multiple ways.

A step by step guide to implement a paired t-test in Power BI using DAX only