Select Distinct Logo Clear Background

Calculated Columns and Measures in Power BI

Calculated Columns and Measures in Power BI

Introduction to Calculated Columns and Measures in Power BI A guide to understanding the differences between calculated columns and measures in DAX for Power BI   What is a calculated column? A calculated column is a static value added to a table, calculated row by row when you load the data. What is a measure? […]

When to transform data

When to transform data for Power BI

As a general principle we should always look to transform data close to its source to gain efficiencies and minimise potential for discrepancies Over the last few weeks we have shown how data can be combined from multiple sources in three different ways UNION in SQL APPEND data in Power Query UNION in DAX A […]

UNION in DAX

Combine data with UNION in DAX

Using UNION in DAX is a third option to combine data for analysis in Power BI We recently showed how to do this in SQL UNION in SQL and how to do similar in Power Query APPEND in Power Query   It isn’t always possible to do this in SQL such as if the datasets […]

Advanced Top N Filter Power BI

Advanced Top N filters in Power BI

The basic Top N filter in Power BI can be very useful, but if you need to show the values of the whole you will need to use an advanced Top N Filter This guide shows you how you can set it up If you use the standard top N filter you would see something […]

TOPN in Power BI

TOPN measure in Power BI

Understanding TOPN in Power BI You have heard of the 80:20 rule (Pareto)? In the world of data analysis, having the ability to efficiently rank and prioritize information is crucial. This is where the TOPN function in Power BI comes into play. By utilizing this powerful ranking function, analysts and data professionals can gain valuable […]

Toggle Measures in Power BI

Toggle Measures in Power BI

Space on your dashboards is a limiting factor Setting up toggle measures in Power BI helps to use the space better One of the key challenges with dashboard building is finding the balance between detail and available space This article shows you how to combine a couple of features to create the ability to toggle […]

Rolling Averages and Rolling Sums in Power BI

Rolling Averages and Rolling Sums in Power BI

Why are rolling averages useful Rolling averages and Rolling totals are used when analysing data over time Rolling averages smooth out fluctuations across the number of periods Both of these are possible in Power BI if you know the steps involved   How to create rolling averages in Power BI Power BI has a really […]

Add a date dimension table in Power BI

add a date dimension in power bi cover page showing a calendar

How to easily add a date dimension table in Power BI in 1 minute What is a date dimension table A date dimension or calendar dimension is one of the most common tables in a reporting data model. It contains one row per date. It also has all different date attributes and classifications that you […]