ehansalytics14 karma2018-11-06 19:01:10 UTC
This is all around Power Pivot and Data Model
When will we see Power Pivot in Excel be brought closer to how we interact with DAX in Power BI? Examples:
View HistoryShare Link
ehansalytics6 karma2020-02-12 18:01:29 UTC
I'd love to see a GROUPBY function. Seems perfect for the new Dynamic Array functions. Group a table by 1+ columns, then summarize other columns by SUM, AVERAGE, etc.
GROUPBY(col, col2, col3, col4, "Total Sales", sum(sales), "Total COGS", sum(COGS))
ehansalytics6 karma2020-02-12 18:10:00 UTC
Conditional Formatting it too small as well.
ehansalytics3 karma2020-02-12 18:16:59 UTC
I spend more time in Power Query than any other aspect of Excel. Love it!
ehansalytics2 karma2020-02-12 17:53:36 UTC
When are we going to see improvements to Power Pivot in Excel that more closely match Power BI. New functions like REMOVEFILTERS for example, or bi-directional relationships?
I've heard it is an issue that when these changes are made it could/would break compatibility with older version of Excel with an older Power Pivot engine, but does that mean it will never get updated for the sake of compatibility? Power Pivot in Excel hasn't seen any improvements since 2016. It is getting harder to use Excel because it is more difficult to replicate measures and the model that are supported in Power BI, and sometimes - sometimes - Excel is the right tool for the job.
Copyright © 2014 BestofAMA.com, All rights reserved.
reddit has not approved or endorsed BestofAMA, reddit design elements are trademarks of reddit inc.