Hi, I need to represent a report that shows weekly trend of YTD average of a sales per region. Any advise on how can I use Power BI to help me? This is the example   Region    Day    Sales Amount A             1         1000 A             2         1500 A             3         700 B             1   ...

Sample data: https://www.dropbox.com/sh/lzgqonrufze6mql/AABDGjIHOvu7iraqXeqKTmA9a?dl=0   We have a "PromiseDate" which is when we tell the customer it will be ready. The product needs to be passed quality control (DatePassedQC) at least one work day prior to the PromiseDate. If the DatePassedQC is o...

Gaining an understanding of Row and Filter Context is among the most difficult challenges facing a new DAX author. Just when you think you've got it, a problem arises and your hard-won mental model seems to crumble before your eye. For a new author this is particularly tricky in that virtually every...

Jumpstart your DAX development with this helpful cheat sheet.

This article describes a number of techniques available to filter tables in DAX, showing possible pitfalls that you can avoid once you know them, in particu

Traditionally, when we do variance analysis, we compare the actual value of the metric being measured to its target value in either absolute or relative terms. For example, if I were to compare cur…

Hi All,   I would be most grateful for some help with my DAX formula for a calculated measure please. I have a fact table 'Fact' and a parameter table 'Reference' (disconnected slicer).   'Fact' consists of three columns: Transactions, Category, Sales - this is at transaction level, i.e. if a custo...

Hi,   I'm looking to create a report that shows monthly totals for the last x months, then for the current month, I'd want it to be able to show a forecast of where the month will get to based on the numbers so far this month.   I have played around with the in-built forecasting tool, but that doesn...

Line charts are indespensable, but they can get pretty busy pretty quick. A chart with several related measures can have so many lines on it that they turn into an indistiguishable visual mess. Wouldn't it be great to give users a chart that's got several measure on it, but it allows them to turn in...

This article describes different techniques to retrieve multiple values from a lookup table in DAX, improving code readability and performance. There are a

DAX Patterns is a collection of ready-to-use data models and formulas in DAX, which is the programming language of PowerPivot. Create your Excel data model faster by using a DAX pattern!

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Scenario A retail firm believes that its sales are driven by an external index that we will call the "Real Wage Index". This index tracks real hourly wages adjusted for inflation, seasonality, etc. The retail firm believes that this index is a 3-month leading indicator, meaning that when the index g...

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Back to Part 1 Download this workbook Here The Formula for the Slope of a Linear Regression Line.  It’s Greek to Me.(Get it?  Gree

Out of 407 Total Combinations of Subcategory and Region, These 8 Stand Out This Month (These 8 Combinations Differed GREATLY from their Respective 12-month

It’s been almost two years since I posted about the CONCATENATEX() DAX function here. At the end of that post I promised to publish a tutorial on how one might do Market Basket analysi…

One type of analysis I like to use quite often is comparing this year totals to last year totals. I want to also always make it as dynamic as possible. All I should have to do is change the context of my calculation (ie. bring in a new dimension like regions/products etc) and everything should autom...

I created a measure that it is accurately giving a running count over a subset of the data Nb cumulatif de DDS_ALL = CALCULATE ( COUNT ( '311_Details'[DDS] ); FILTER ( ALL('311_Details');('311_Details'[Nature]"Information")&&( '311_Details'[Date de Création]

This is actually the fifth post on Slicers, which means that it’s something that keeps coming up and that its something important to learn.

This article describes how table expansion and filter context propagation are important DAX concepts to understand and fix small glitches in DAX expressions