dax

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 …

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 …

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

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…

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…

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

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

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…

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.

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…

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…

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 [...]

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.

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…

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 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

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…

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...

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…

If you are an advanced Excel user already familiar with PivotTables, eventually you will surpass regular features Excel has to offer, and you will start using PowerPivot. Why? Because in today’s world it is all about Big data. There are so many sources available for analysis,the amount of data is bigger than ever and increasing each day with astonishing speeds....

In this Power BI Tutorial, Patrick looks at how to dynamically filter by today’s date. Using a date table, you can create a DAX measure that can then be used as a Power BI report-level filter to dynamically filter by today’s date within Power BI Desktop.

In August 2018, the Power BI team has released a new feature: conditional formatting by field value. This feature works for both background colors and font colors. Because different background colors …

Hi, based on the last update Power BI video of SVG visualisation here is a measure, that creates simple KPI. User has to add reference for 3 values: Main Value, Goal and Max Value. Based on values KPI color is changing to green or red. User can also change colors or edit if function for color cha...

When I read about the new conditional formatting by values feature in the August 2018 release of Power BI Desktop, my first thought was to write a blog post on how DAX can be used to generate the hex …