From the Water Cooler As a 'water cooler' of sorts for this community, we meet some amazing people. Matt Mowrey shares with us a really useful technique to

Works! Now I need to find out why it works. Many thanks, Lydia

This article describes how to use variables to optimize the performance of DAX expressions containing multiple instances of the same measure or the same sub

GUESS WHO'S BACK, BACK AGAIN Krissy's back, tell a friend! Guess who's back, Guess who's back, Guess who's back. Guess who's back… Well, as probably most o

Where I am consulting there was a requirement where for the current month they wanted to display the Current Month Estimate for the current month they were in, and to show the historical sales for …

Hi! I have calculated cumulative forecast and cumulative recorded sales. I need help with a DAX-expression to alter my forecast based on the results of the recorded sales: Example: Original forecast says 10$ per month, cumulative this will give january 10$, february 20$, march 30$ etc... Resulting ...

Introduction Mean Time Between Failure (MTBF) is a common term and concept used in equipment and plant maintenance contexts. In addition, MTBF is an important consideration in the development of products. MTBF, along with other maintenance, repair and reliability information, can be extremely valuab...

Try This Calculated Column Duplicates = VAR mycount = CALCULATE ( DISTINCTCOUNT ( TableName[surrogate] ), ALLEXCEPT ( TableName, TableName[Parent] ) ) RETURN IF ( TableName[Brand] = "ST", IF ( mycount = 1, "Pass", "Failure" ), "N/A" )

Greetings, I have a table of municipal water consumption records. I'm trying to create a monthly average of gallons used by residents. I need to filter the table by Rate Class = "Residential." Looks easy enough, but my DAX calcs seem wrong. Here's the DAX: Avg Monthly Vol Residential:=CALCULATE(...

Hi Community, I've one question, maybe a silly one, but I already wasted some time trying to solve the following requirement... I've the following very simple star schema model in my PBI file, and what I want to do is to roll up the value measure per Country Name... I'm able to roll up the value...

May be a MEASURE instead of a column would handle memory better. Try this MEASURE Time Difference Measure = VAR NextRow = CALCULATE ( MIN ( TableName[Date/Time] ), FILTER ( ALL ( TableName ), TableName[Date/Time] SELECTEDVALUE ( TableName[Date/Time] ...

This builds off of my original article here: https://community.powerbi.com/t5/Community-Blog/Correlation-Seasonality-and-Forecasting-with-Power-BI/ba-p/14147 and 's take on that approach here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Correlation-coefficient/m-p/196274 To introduce...

Hi , You may download my solution from here. Hope this helps.

Hi See the attached file here With your sample data and solution

Detail Row Expressions Detail row expressions is one of the top new features of Analysis Services 2017 (1400 Compatibility Level) as it provides the equivalent of a drillthrough action for users to…

Hi, Try this =LOOKUPVALUE(Data[Sales],Data[Month],CALCULATE(MAX(Data[Month]),FILTER(Data,Data[Job ID]=EARLIER(Data[Job ID])&&Data[Month]

Try this: [SubCategory Sales] = VAR CurrentSubCategory = VALUES ( ProductTable[Product Subcategory] ) RETURN CALCULATE ( SUM ( Sales[Sales] ), ALL ( ProductTable[Product Name] ), ProductTable[Product Subcategory] = CurrentSubcategory ) and this: [Category Sales] =...

Precisely-Timed Measurements vs. Imprecisely-Timed Events: How Do We Correlate/Relate Them? The Streak is Broken… and a new streak begin

If you are an advanced Excel user already familiar with PivotTables, eventually you will surpass regular features Excel has to offer, and you will start using PowerPivot. Why? Because in today’s world it is all about Big data. There are so many sources available for analysis,the amount of data is bigger than ever and increasing each day with astonishing speeds....

This article explains how the context transition interacts with the filter arguments of a CALCULATE function in DAX. This is important in order to avoid une

The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This ar

Level: Intermediate–Advanced I have covered the topic of Lineage in DAX a few times in the past (within other articles). Today I thought I would write a single post dedicated to lineage. As you may kn…

Wham! It's a hands-on technique! In a recent post, I hinted that I’d be using the Football Project V2 as my “platform” for some future techniques-oriented

I remember feeling that way, Mr. Badger, but they’re simple… if you can SEE them! Have you ever needed to SUMX() over the values in more than one column? S

Hi , In this scenario, the formula below should work. :smileyhappy: _Release Count = CALCULATE ( COUNT ( 'Release Count'[Personnel Number] ), FILTER ( ALL ( 'Month Year'[Date] ), 'Month Year'[Date]

This article shows a technique in DAX to compute the sales volume of products that were available right from the beginning of a selected time period, ignori

Change the axis of a pivot chart or the rows/columns of a pivot table... dynamically using a slicer!