dax

usiness users often need to know how fresh the data is that they see on a Power BI report. This requirement can be interpreted to mean either “when was the last date & time that the sour…

In this article we look at four different ways to query data from within Tabular Editor. I also share a C# script to query or test selected columns and/or measures.

DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article shows the effect of not having a blank row in your tables. We dedicated a previous article to the blank row in DAX. In that ar

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

Helpful intro for Windowing Functions

Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. This whitepaper is a draft.

DAX is more than the name of my new puppy

This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Finding errors in DAX

This short post explains how to format Power Query automatically in Tabular Editor using a C# Script to call the powerqueryformatter API.

We look at how Tabular Editor shortcuts can revolutionize your productivity, linking them to macros, common actions and more.

This short article explains how to quickly count measures (or any model object) in Tabular Editor. A C# script is provided to count all model objects as a quick pop-up.

Reading Time: 2 minutes A challenge to which I infrequently return is attempting to create various “new” chart types using only Power BI’s native visuals. For example, I have tried to replicate a Horizon chart and Slopegraph in Power BI without the use of...

DAX window functions can result in simpler, more efficient SQL when using Power BI DirectQuery mode and a greater likelihood that aggregations are used

The DAX OFFSET function has been talked about for a while now. The main entry point to this function for almost everyone was the article by Marc Lelijveld How to OFFSET in DAX would make your life easier – Data – Marc (data-marc.

There are new DAX functions: INDEX, OFFSET, and WINDOW. These functions allow us to compose powerful filter tables that have not been possible before or at least require very complex DAX code. These functions come with additional clauses, namely ORDERBY and PARTITIONBY. PARTITIONBY enables the partitioning of a virtual table.

This is the second installment in our two-part series on DAX window functions announced in the December 2022 release of Power BI Desktop. I will first answer the questions that I had received from …

The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL wind…

This video explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool.

The filter arguments in CALCULATE can be written as logical conditions with certain restrictions. This article explains the more common errors in these cond

New window functions are one of the most important enhancements to the DAX language ever! Learn how to leverage them to calculate a customer lifetime value.

Explaining changes between snapshots is not easy, but calculation groups can help show exactly what happened in terms of Value changes, movements, etc.

Power BI Update - December 2022

I enjoyed testing the new WINDOW DAX function in Power BI with different use cases. In this blog, I will share with you some use cases of the WINDOW function announced in the December 2022 updates of Power BI . I tested the new OFFSET and INDEX functions 👉

It's nice to see that #ChatGPT has found that many #dax functions are just #excel ones. It explains why it is shameless to suggest them. But you can guide the AI to something that works.A 🧵1/13 pic.twitter.com/bZafvz0esr— Marco Russo (@marcorus) December 10, 2022

The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL wind…