Learn to Write DAX by Matt Allington

Author:Matt Allington
Language: eng
Format: epub
Tags: dax;excel;business intelligence;power bi desktop;microsoft;big data;data analysis;microsoft;msbi;pivot table;pivottable;powerpivot;spreadsheets;DAX;formulas
Publisher: Holy Macro! Books
Published: 2015-11-07T00:00:00+00:00

A Word on Table Sorting

In the example above, you can see that the month names in the pivot table are sorting in alphabetical order rather than in the logical month order of a calendar year. All columns in all tables sort by default in alphanumeric order. It is, however, possible to change the sort order.

Here's How: Changing the MonthName Sort Order

Follow these steps to change the sort order in a table:

1. Go to the Power Pivot window and navigate to the Calendar table in the Data view.

2. Click in the MonthName column (see #1 below), and then click the Sort by Column button (#2) and then Sort by Column (#3).

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.