dax

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

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

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

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 See the attached file here With your sample data and solution

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

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

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

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

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

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" )

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

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

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 …

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

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

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

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

Try this calculated column Column = VAR currentdate = TableName[Date] VAR PreviousDate = CALCULATE ( MAX ( TableName[Date] ), FILTER ( ALLEXCEPT ( TableName, TableName[Country], TableName[Product] ), TableName[Date] currentdate ) ) RETURN...

, Just change it as follows. DIVIDE ( COUNT ( Students[Student ID] ) - prev, prev )

Hi , Based on my test, you should be able to just use the formula below to create a new calculated column in your table to get Running Balance. :smileyhappy: Running Balance = CALCULATE ( SUM ( Table1[Amount] ), FILTER ( ALL ( Table1 ), Table1[SUPLIER] = EARLIER ( Table1[S...

Hi Do you mean, you want to make sure filters set external to the matrix are applied to the calculation? If so, try this.... ACD Time (min) = VAR TotalSeconds=SUMX(ALLSELECTED('agent_interval') ,HOUR('agent_interval'[acdTime_i_HHMMSS])

If you have a term table like so (let's call it SecTerms): And then another table with a text column (let's call it Companies) like so: Then the following measure will work in a matrix: TermInstance = SUMX(SecTerms, SUMX(Companies, SecTerms[Weight]* (LEN(LOWER(Companies[De...

I am trying to do some advanced DAX/PowerQuery equations and I am coming up short and looking for some help. I have a dataset like the below and the use case is to get an average amount of time spent for each 'code'. To come up with that I need to take each true value timestamp and comare it agai...

Hi, Trying to work out the DAX measure to count the rows if the sum of the amount is greater than 0 per ClientID, but to no avail. Data is as follows: ClientID Amount 1 0 1 10 2 0 3 100 Each row is a meeting, and I need to count the number of meetings in the case that the sum of the amount p...

Maybe this: Rolling 3 Month Total = CALCULATE ( KPI_Finance_Actual_Budget[Actual Profit], DATESINPERIOD ( KPI_Finance_Actual_Budget[FullDate], LASTDATE ( PREVIOUSMONTH ( KPI_Finance_Actual_Budget[FullDate] ) ), -3, MONTH ) ) Although if "KPI_Finance_Actu...

There are two themes for this month’s Power BI Desktop update. The first is a focus on some of your major asks including multi-selecting data points across multiple charts and syncing slicer values across multiple pages of your report. We also have a major update to our SAP HANA connector. Our second theme is a focus on performance improvements across three different areas of our product.