What’s Happening with “Quick Calc” in Power BI?

In the Power BI Desktop update last May, Microsoft released “Quick Calc”. As a convenient feature that eliminates the need to write a custom DAX expression for a simple percent of total calculation, it was lauded at the time of release.

Even for SSAS tabular developers who have been writing DAX % of total calculations for years, Quick Calc is promising because it saves time and eliminates unnecessary measures. For anyone new to Power BI, it eases a training burden and helps answer the question, “Why would I need to write DAX for something this simple?”.

quickcalc

 

Back in May, dreams were born for additional DAX-free calculations. In that idealistic world, we would not need to write custom measures for things like running totals, period over period change, and more. Everything you had in Excel pivot tables would not be far behind % of Grand Total in Power BI:

PowerPivot.PNG

 

It’s now been a few — wait…sorry, I’m not in the habit of doing basic calculations without DAX first.

QuickCalcTimeSinceRelease.PNG

Ok, thanks for your patience. It’s now been five months with no changes in Quick Calc functionality in Power BI Desktop, and it has yet to reach the online Power BI Service (without first being published from Desktop). Does Quick Calc have a future with the addition of more convenient built-in calculations? I hope so.

DAX is suitable for more complicated calculations,  but if you are interested in expanding Quick Calc, here are some ideas that you can vote on from the Ideas forum:

Advertisements

2 thoughts on “What’s Happening with “Quick Calc” in Power BI?

  1. David,

    Microsoft isn’t exactly closing the gap on competitors in this regard. I thought I was being misinformed when I was told that there was only one quick calc available last month when I first started looking at PBI. Thanks for verifying this information. I’m still suffering a little shock and awe from this fact.

    Ken

    Like

  2. I’d actually prefer a “DAX Helper” over the QuickCalc. Why can’t an assistant pop up – “what do you want to aggregate?” it says (remember Clippy?). I answer some questions, apply some filters & BOOM – a new measure with @Macro-beautiful DAX (with comments). Use me anywhere! Heck, cut/paste me into Excel too. And, oh by the way, you might accidentally learn DAX – heaven forbid. Kill QuickCalc !

    Like

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s