dax

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 …

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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]

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

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

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…

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

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

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