DAX

I was recently doing some consulting work for a customer and they had a column which contained seconds and whilst this is useful it is better to have it shown as Minutes and Seconds, which is easie…

Similar to Net Work Days, Net Work Duration calculates the total duration between two date/time columns taking into account non-working days (weekends) as well as the start and end times for a work day. This version calculates duration in minutes, although this can be easily changed. mNetWorkDur...

Earlier this year at the Data & BI Summit I gave a presentation titled “DAX Query Use Cases” which, among other examples, featured several paginated reports (aka operational or Repo…

In Part I, we used the query editor and the M List functions to generate all the possible combinations of five and seven cards from a standard deck. To score all the possible combinations of seven cards (133M possible hands X 21 ways to pull 5 cards from 7 X 5 cards/hand = >14 billion rows) was more than my

This article describes how to use a measure to filter a Power BI visualization and what is the different behavior of a similar filter between different visu

In this session we will look at all the important topics that are needed to get your Microsoft Power BI modelling skills to the next level. We will cover items like the in memory engine, relationships…

In this video, Patrick shows you how to use Power BI conditional formatting by another column in Power BI Desktop. Using conditional formatting by another column can help you provide context which leads to faster insights. Power BI capability arrived in the May 2018 release of Power BI Desktop.

I am proud to announce another joint development game between Philip Seamark and myself (Mike Carlo) of a Tic Tac Toe game. To read about [...]

Last month I saw a puzzle posted on fivethirtyeight.com about poker hand probabilities and, like with many things these days, wondered how I could solve it with PowerBI. I had been curious to learn mo…

One of those days where I spent a reasonable amount of time trying to solve a tricky DAX expression and once I got it; I came to know it was…

Power BI lacks the ability to add KPI calculations when creating a data model in Power BI Desktop. I will show you how to get the same functionality by using the recently released feature “Conditional Formatting by a Different Field”. This will allow you to take a calculated score and have an Icon displayed for each row in your table. A working Live Interactive Power BI Sample is attached at the bottom of this post.

I got an interesting question from Vijay asking, “How do we do a slicer with data count?” This is what Vijay was looking to achieve as shown below and I always enjoy a good challenge. A…

In this Power BI tutorial, learn how to tell the difference between calculated columns and measures and discuss use cases for each.

Below some DAX queries. EVALUATE ‘Dimension’ EVALUATE ‘Fact’ EVALUATE ‘Dimension’ ORDER BY ‘Dimension'[Id] START AT 3 EVALUATE CALCULATETABLE(‘Dimens…

Recently someone asked me what is the best way to filter on multi-valued columns in Power BI. The question was in the context of Tags property of the Work Items - Today table in the Visual Studio Team…

Parent-child functions in DAX are very useful for parsing an organizational hierarchy or something like a chart of accounts. Usually, for hierarchies that the number of levels is not determined, you n…

This article describes how to use the detail rows expression of a measure to obtain the equivalent of creating table functions in DAX. This allows the reusi

If you work with Excel Pivot Tables, Power BI, or Analysis Services Tabular more than likely you are working to improve your DAX skills. I know I am. While I do a lot of work with DAX, I am always …

Below was a question from the Power BI Community where the output was to have a calculated column in the Date Table, which would have Today for Todays date, Yesterday for Yesterdays Date, and Next …

There are 3 types of evaluation contexts. Row Context Row context includes the values from all columns in a row and related rows. Row contexts doesn�t propagate through relationships (from the one sid…

Hi folks, After long time I feel to blog about this simple steps to add link to send email (Actually to open outlook to send email to specified email id) Click on enter Data Type here your message - A…

Two of the most fundamental and ongoing questions in BI are 1) “What data and logic do we need in the data model?” and 2) “What data and logic do we currently have in the data mod…

With the modern editors that have automatic code formatting features, each one has its own code formatting style. Usually there are a few “common rules”