Power BI

Tabular Models, Multiple Data Sources and Unknown Members via Instapaper https://sqlserverbiblog.wordpress.com/2015/12/28/tabular-models-multiple-data-sources-and-unknown-members/

Get with Jason on Active Partners/Active MarginSO_OppoturnityCW: 0F68B2LT: 348C35 or 50B848QL: 775EA6 or 836AB8LicenseValue - in Instance, grouping of Licensce or Package, CustCol...

Total Margin for Power BI in Sales_opps_wonTotal Margin = IF([ProdType]= "product" , [qty]*[margin], [Margin])Total Margin for SSMS in Sales_opps_wonsum(CASE WHEN [ProdType] = 'Product' t...

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…

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…

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

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…

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…

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…

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