DAX

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!

We Want to Flag Rows in our Companies Table (on left) When TheyContain a Keyword from our MatchList Table (on right) These are a few of my favorite

Hi See the attached file. Hope it helps Here are the steps Step#1 Determine the First and Last Years with Actual data using these MEASURES FirstYear = FIRSTNONBLANK ( ALL ( YearTable[Year] ), CALCULATE ( SUM ( MeasureTable[Revenue] ) ) ) LastYear = LASTNONBLANK ( ALL ( YearTable...

Please try this as a caluculated column Is 2nd Tuesday = VAR a = 'Dates'[Date] VAR y = FILTER( ALL(Dates[Date]), YEAR('Dates'[Date]) = YEAR(a) && MONTH('Dates'[Date]) = MONTH(a) && DAY([Date]) > 7 && DAY([Date]) < 15 && WEEKDAY([Date],3) = 1) RE...

Hello everyone, I'm new in DAX and I have a big problem with a measure (sorry my bad english). I need to calculate the average of Distinctcount for 7 days moving, for that, I'm counting distincts rows every day like that Vehiculos Totales:=DISTINCTCOUNT(VEHICULOS[PATENTE]) Second, I need to do ...

by Matt Allington I was recently helping a forum member at http://powerpivotforum.com.au with a problem about how to dynamically calculate an employee’s ag

Thanks very much for your timely assistance, ! Works like a charm! thank you.. thank you.. thank you

Hi , you're going in the right direction - the signal growth = today's value - previous day's value The previous day's row could be thought of as having the maximum timestamp that's less than today's timestamp. There is probably a more elegant way to express this idea, but this is how I'd do it ...

Currently, Power BI does not have a built-in feature that enables you to switch between hierarchy le...

Dear all, I’m new in power BI and I have a problem for calculating a weighted average based on a total of a column. In attach a simplified example for my PBIX. As you can see I have two table, a master table and a summarize table, with few fields calculated from master table. On summarized table I h...

This article describes a counterintuitive behavior of BLANK in DAX measures affecting Power BI, Analysis Services, and Power Pivot. That behavior could caus

Use stats functions in Power BI to calculate the daily average sales for any given date range.

I recently stumbled across a strange behavior of HASONEVALUE, which also impacts the SELECTEDVALUE f...

During a conversation at PASS Summit, one of the developers of Power BI shown me a way to use TREATAS...

bring the awesome to moving averages with text formulas for slicer and title— and yes, a Greatest Formula In the World (GFITW) version for custom calendars

We show you how to use a KPI or card as a slicer.

Confused about a Power BI Term? Check out our Dictionary.

There is a new DAX function coming soon to Power BI Desktop: COMBINEVALUES. It concatenates an unlimited number of values with a delimiter. You can already use the function by connecting to a dataset …

I first learnt about the new DAX UNICHAR function in Power BI by reading Chris Webb’s blog (which was also the inspiration for this article today). One of the uses of the UNICHAR function is to be abl…

Despite all articles, blog posts, and videos on the topic of DAX Measures and Calculated columns, I still hear here and there that people ask what is the difference between Measure and Calculated Colu…

Level: Intermediate Background I was reading the questions at http://community.powerbi.com today and saw an interesting question. In short the OP wanted to know if there was a way to identify (via a m…

This article introduces a technique to filter and productively compare two time periods with Power BI. Time intelligence calculations are among the most re

This measure allows you to predict dependent values Y from independent values X. NAME: Simple linear regression DESCRIPTION: Estimate Y values based on X values. PARAMETERS: Name: Category Tooltip: Th…