Power BI

"I like big aggregations and I cannot lie You other PBI'ers can't deny" The attached PBIX file contains a slew of aggregations that span multiple columns All standard quick aggregations are included, namely: Max Min Sum Average Count Count (Distinct) Variance Standard Deviation Median This te...

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-...

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...

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...

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

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

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

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.

, 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

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

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.

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…

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 →

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…

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…

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

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

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…

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...

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.

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...

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...

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, …

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...