Sorting By Financial Years In Power BI

2 comments

I get this question a lot in many of the live trainings that I do, and it’s how can I sort my dates by the financial year.

Now, obviously, not everyone’s year runs over the calendar dates or the calendar year.

Your financial year might start at July, it might start in August, November, something like that.

Not only that, your quarters will also be in different order too because Quarter 1 might not be January to March, it might be July to September. So you need to somehow figure out, how to sort your date tables to manage this.

In this example, I show you exactly how to do it. It’s actually not too difficult. The key thing that you need to know first is how to actually sort any column inside of a table, and so I certainly show you how to do that.

From that, we need to add just a little bit of logic based on our financial year into the date table. Then we can use that as a sorting column for our months or quarters.

That’s it…just a little bit to it.

Once you do this once or twice, you’ll certainly understand it for the future and be able to implement it relatively easily and seamlessly into your models, especially around when you have to adjust them or alter them by the financial years that you’re working in.

This could also be very relevant for custom calendars, as well, because I know with customer calendars sometimes your weeks and months are aligned differently to the standard calendar year dates. You could apply this very same technique in those sort columns in that scenario also.

Good luck with implementing this one. Certainly not too difficult but certainly worth learning and implementing in your own models.

***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – Power BI Resources

2 comments on “Sorting By Financial Years In Power BI”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s