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…

A few years ago I wrote this post on how to alias columns in a table in DAX, using a combination of AddColumns() and Summarize(). The good news is that in Excel 2016/the Power BI Designer/SSAS Tabular…

I had a requirement where I had a measure that I wanted to be filtered if it’s value was selected then it must show the value. As well as if nothing is selected on the slicer then I also want…

I got an interesting request this week, to improve the usability of the tabular model they wanted to filter the dimension table to only contain the rows that have data in the fact table. That way t…

This article describes how to create a table with a series of numbers in DAX by using the new GENERATESERIES function or through a workaround using CALENDAR

DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.