DAX

In SQL there are different types of JOIN, available for different purposes. This article shows the equivalent syntaxes supported in DAX and it was updated i

Published on May 13, 2018: In this video, we will learn about 1. The background of people who learn DAX and why they encounter difficulty 2. What concept tak...

Obviously T-SQL and DAX are two different query languages and it serves entirely different purposes.However, as a person who came from database development background , when I learn DAX initially, …

Hey guys!! You might have seen my previous post about adding working days. This is still part of the same problem, however, I've established a method that I need help writing the correct code for. Assuming my date table looks like this: (May 9th is a holiday for example purposes) Date Wo...

Hi , You can add a new column: Count Per Id_Page into category = var c1=CALCULATE(COUNT(Table2[IdPage]),FILTER('Table2','Table2'[IdPage]=EARLIER(Table2[IdPage]))) return IF('Table2'[Index]=CALCULATE(MAX('Table2'[Index]),FILTER('Table2','Table2'[IdPage]=EARLIER('Table2'[IdPage])&& Table2[IdCatego...

In this post you learn how to leverage DMVs to get SSAS Tabular and Power BI Model object dependencies. It is easy to find DAX Measures dependencies, calculated column dependencies and much more. I made a tool in Power BI which is available for you to download for free.

While it would be a bit presumptuous to presume that any single formula could account for all possible measure total situations, the following pattern is presented for handling matrix measure values as well as subtotals and grand totals. This pattern has the added flexibility of being able to handle...

Power BI offers the ability to create Groups and Bins to help consolidate data into a more presentable or meaningful visualization. You can also recreate a lot of what you would typically do in the UI…

A recurring issue for Power BI users writing DAX code is that column filter removal might have an unexpected behavior when the Sort by Column is active on t

In the latest weeks I received several requests to support a different color for variable names in DAX Formatter, just as the formula editor available in Po

I had a requirement where my customer was looking to gain some insights into their data relating to reactivated players. The definition used for a reactivated player is a player that has previously…

What I am doing with the DAX below is to only show the concatenation of values if a value is filtered. If nothing is filtered (Selected) then display text to show that nothing has been selected, ot…

Yesterday I was working on a data set, and needed to work out the Top x with Ties in Power Query. This posed to be a bit more challenging than I first thought it would be. Why did I want … Continue reading →

Introduction This is the latest post in my series "Fun with Graphing in Power BI". It might be my last as well. There are a few different reasons for that. First, and most importantly, I believe I may…

In this tip we show how you can calculate employee attrition rates. You can apply these methods in Power BI Desktop, Analysis Services Tabular or Azure Analysis Services.

Hi , This is what I was talking about : https://drive.google.com/file/d/1NK1xeEJT8tE1KmBEPXY2l8GeAsxWTVHG/view?usp=sharing Hope it helps... Ninter

, Please check if the following DAX returns your expected result. If not, please share sample data of your table and post your desired result. Measure = COUNTROWS(FILTER(ZeroTFSlLevel,ZeroTFSLevel[PlaceOrPte]="Pte"&&ZeroTFSlLevel[Enrol_count] = 0)) Regards, Lydia

This article describes how to implement in DAX a logical OR condition between the selection of two slicers of a Power BI report or of a PivotTable in Excel.

How do you optimize a DAX expression? In this session, Alberto Ferrari analyzes some DAX expressions and Tabular models and, through the usage of DAX Studio

As with any other language, you can write good DAX but you can also write bad DAX. Good DAX works fine, it is fast and reliable and can be updated easily. B

Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals…

Builds off of First Working Day of Week here: https://community.powerbi.com/t5/Quick-Measures-Gallery/First-Working-Day-of-Week/m-p/391332 Provides the same functionality for First/Last Working Day of the Week, Month, Quarter and Year as well as logical true/false tests for these. Included below a...

Suppose you have some data like this: ID DimKey3 DimKey4 DimKey5 DimKey6 1 blue red green green 2 blue blue red blue 3 blue red blue blue 4 green green red green 5 green green blue green 6 red red red red 7 blue blue blue blue 8 green green green green 9 blu...

Similar to Rolling Months, https://community.powerbi.com/t5/Quick-Measures-Gallery/Rolling-Months/m-p/391499 it is often handy to have the ability to do rolling weeks. For this to work, previous Quick Measures of Week Starting and Week Ending are required. https://community.powerbi.com/t5/Quick-...