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

You can connect an Excel workbook to a Power BI model in two ways: Using the Analyze in Excel action in powerbi.com Using the Connect to Data action in the

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

Zoe Helps Me Answer a Long-Simmering Question This summer we welcomed Zoe Stein (an Industrial Engineering major from Georgia Tech) to the team for a summe

Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about.

NAME: Arrow Rating   DESCRIPTION: This quick measure shows an up arrow or down arrow when comparing a target value against a target value, or else "--" if not. Can also be inverted if a lower value is better compared to the target.   PARAMETERS: Name: Base Value Tooltip: Your base value / measure. T...

Hello, I want to calculate the time difference of same type occurrences. What I already did was to get my data in the following format by duplicating the table (and adding index columns, one beginning with 0 and the other with 1) and merging them by means of a outer join. Then I added a calculated...

I have been working with DAX for quite some time now, and I've come across a rather complex Percent of Total Revenue request.  I'm thinking DAX should be able to accomplish this fairly easily as Pivot Table calculated fileds makes it easy enough.  First off, to calculate Percent of Total Revenue for...

I was giving my Row Level Security session last weekend for the Richmond User Group ( @RichmondSQL   http://rva.pass.org/) and a question came up (ok, so I technically asked the question). How does the feature work with indexed views? Generally speaking,

This article describes how DAX resolves column and measure names in DAX, providing best practices to avoid conflicting names. A fundamental rule you should

Hi,   I'm trying to create a measure to be used as a tooltip in a treemap. The tooltip should show a list of the top 5 sub-items with a total.   For example, each tree item in the chart is a state. The tooltip should show the 5 top cities in the state and the total value for each city.    I'm able t...

I have a table with a population of people and a value per person. I need to build a single measure to calculate the average value by tier. The tiers should be defined by % of people sorted by value, e.g. 60% bottom, next 20% and top 20%.   Usage of a parameter table to easily adapt the numbers and ...

Hello,   I am currently working with a data set to produce cumulative counts (which I have working perfectly) however I have a problem with my next step.   The data should all at some point go through "Stage 1" however due to various reasons it doesn't always happen.   My data looks like this:   ID ...

Hello,   I'm new to Power BI and I'm stuck with a problem. I have a table with calls including the fields customer, start_date and end_date No I want to see how many call are active during a given period (line chart or similar over the period would be good) e.g. Customer Start_Date End_Date A 27.06....

This is the data I have: (Grouped by Lot and Site) Table1: Lot_PK Device Lot Site Total Parts-Phase1 Passed Parts-Phase1 Yield-Phase1 Total Parts-Phase2 Passed Parts-Phase2 Yield-Phase2 1 D1 L1 1 100 80 80 20 15 75 1 D1 L1 2 100 70 70 30 20 66.67 2 D1 L2 1 100 70 70 0 0 0 2 D1 L2 2 100 85 85 45 35 7...

This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or

Got a good question this week that had me scratching my head for a bit but then I remembered a new function that was added to Power BI (and SSAS) recently called TreatAS. Marco covered it in detail…

A few weeks ago I was asked whether it was possible to display line breaks in text in a Power BI visualisation. It turns out it isn’t possible – at the moment Power BI always strips line breaks out…

There is a video that walks you through the solution in depth, please find the video at the end of this post along with the completed solution. In this installment of the Problem, Design, Solution …

Normalize numeric data from several independent ranges to a uniform scale ranging from 0 to 1. This can be used as a precursor for clustering, creating parallel coordinates plots, and more.   Follows formula: (x-min(x))/(max(x)-min(x)) Using the DAX measure:   Normalized Value = VAR MinOfGroup = CA...

Hi Everyone,   So I have a following Data Set:   Revenue CustomerKey 10 1 20 2 30 3 25 4 45 4 60 5 100 3   What I am struggling with is getting how many customers bring 50, 30 and 20% of Revenue respectively.   I am trying to get:  % Revenue Customers 50% X 30% Y 20% Z   You help would be much appre...

Hi,   I've got some Google Searchconsole Data and I want to create a tile that compares the Average Position on a certain date, which is chosen by a slicer, with the Average Position one week earlier. The following just gives me a "(Blank)":   AveragePositionOneWeekEarlier = CALCULATE ( [AveragePosi...

A B C D E 1 A o 1 0.8 2 A o 212 0.5 3 A o 23 0.2 4 A o 45 1 5 B o 343 0.3 6 B o 32 0.4 7 B o 234 0.5 8 B o 213 0.6 9 C v 65 0.7 10 C v 678 0.8 11 C v 564 0.6 12 A v 23 0.6 13 A v 12 0.6 14 A v 32 0.6 15 A v 11 0.6 16 E v 22 0.6   I have the above table ... I wanted to calculate the weighted avarage ...

Hi,   I'm trying to figure out how to idenitfy new merchants based off transaction data. I have a transaction table that has merchant info included. The firstdate function looks like it has worked when I create a table of merchant ID and first transaction date. But I'm not sure how to sum the new me...

Okay, here is a head scratcher for you all. I have a table in Power BI which list contract dates. So it will have columns such as below..   Product     StartDate    EndDate     LOS Product1    20/11/17      30/11/17    11 Product2    02/01/16      19/03/16    78   I need to work out how long a produ...

Hi,   I'm hoping to use PowerBI to show overall market trends as well as trends in individual accounts. My data has several different slicers, e.g. location, device type, etc.   Is is possible for me to show two lines on a line graph, one for the overall marketplace average, and one for the individu...

Hi guys,   Would appreciate some's help with this;   I have a SALE Table and a Calendar Table with Financial Years ending June. I would like tp categorise clients in the Sales table as "New" or "Exisitng". If a client was invoices in the previous financial year then its flagged as "Exisiting". If a ...

Hi All,   I'm new to BI, and would really appreciate your input on what would be the next steps to take for a report I'm working on. Currently, I've a list of projects (PO's), with several criteria that need to be met before they are completed. Once all criteria are met, the PO in general is complet...