Microsoft has just released a new version of Power BI Designer with some great new features borrowed from Power Pivot.
In Power Pivot, you can create a “calculated column” based on existing data in your table. This is a great way to format dates, create profit calculations from existing raw data or to transform your data. This is now supported in Power BI Designer – huge improvement!
Sort by Another Column
When working with dates, you might have a column for “Month” that has the values January, February, March, etc. If you try to sort them, they’ll sort by default in alphabetical order instead of in date order.
In Power Pivot, you can take column like this and have the sort order driven by another column. In this scenario, you have a separate column that has the date representation of the month (e.g. January = 01/01/2015, February=01/02/2015, March=01/03/2015, etc.) and you can specify that your month column should be sorted not by its own natural sort order but by your date column which is sorted in date order. This is a key requirement for any plotting of graphs based on dates.
This is now also available in Power BI Designer!