# Quick DAX: Use GENERATESERIES to create Time buckets

A not so obvious use of the recently added GENERATESERIES function to use it to generate time buckets.  The more common use of this function is to generate series of numbers, but it works just as well with Time based data. Say you want to create a data table with rows that represent time periods.  Read more about Quick DAX: Use GENERATESERIES to create Time buckets[…]

# DAX : Convert Number into Month Name

I sometimes see requests asking how to convert a number between 1 and 12 into a month name such as “Jan” or “February. The most common solution I see offered is along the lines of a SWITCH statement that lists 12 conditions (one for each month).   This works, but can also be done using existing Read more about DAX : Convert Number into Month Name[…]

# Fun with DAX – Compressing Numeric Sequences to Text

A recent post on the Power BI community website asked if it was possible to compress a group of numbers into text that described the sequential ranges contained within the numbers. This might be a group of values such as 1, 2, 3, 4, 7, 8, 9, 12, 13:  (note there are gaps) with the Read more about Fun with DAX – Compressing Numeric Sequences to Text[…]

# Add Photos to Power BI from Active Directory

If you work for an organisation that stores thumbnail images of staff inside Active Directory, you can probably access these and incorporate the images in your Power BI Reports.  This is a great way of making an internal staff report look fantastic – and it’s easy! Step 1. Click Get Data from the Home tab Read more about Add Photos to Power BI from Active Directory[…]

# How to use RANKX in DAX (Part 3 of 3 – The Finale)

Part 1 of 3 Using RANKX in calculated measures Part 2 of 3 Using RANKX in calculated columns This article concludes my epic series detailing how to use the RANKX function in DAX.  In this episode, Frodo finally reaches Mt. Doom and successfully uses RANKX to find the best path into the mountain and complete Read more about How to use RANKX in DAX (Part 3 of 3 – The Finale)[…]

# How to use RANKX in DAX (Part 2 of 3 – Calculated Measures)

The first article in this series looked at to use the RANKX function in a calculated column to apply ranking to your data. This article will show how you can use the RANKX function in a calculated measure. The PBIX file used for this article can be downloaded here. I will use the same 10-row data-set and Read more about How to use RANKX in DAX (Part 2 of 3 – Calculated Measures)[…]

# How to use RANKX in DAX (Part 1 of 3 – Calculated Columns)

How to use RANKX in DAX (Part 2 of 3 – Calculated Measures) When I first started to play with DAX, one of the functions that seemed to confuse me more than it should, was how to add ranking to my data.  It didn’t seem to matter what the data was, if I followed the Read more about How to use RANKX in DAX (Part 1 of 3 – Calculated Columns)[…]

# Dynamic Date Range from Slicer

A recent post on a community.powerbi.com forum asked if it was possible to show a slicer of months, and configure a report so when a user selects a single month from the slicer, visuals will show data for a date range relative to that selection e.g. the preceding  10 months of data. If a user Read more about Dynamic Date Range from Slicer[…]