Power BI Designer Updated with Two Important Features from Power Pivot

Microsoft has just released a new version of Power BI Designer with some great new features borrowed from Power Pivot.

Calculated Columns

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!

Christopher Woodill

About ME

Enterprise technology leader for the past 15+ years…certified PMP, Six Sigma Black Belt and TOGAF Enterprise Architect. I collaborate with companies to help align their strategic objectives with concrete implementable technology strategies. I am Vice President, Enterprise Solutions for Klick Health.

Leave a Comment