ehansalytics

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:

1. a much better DAX/Measure editor – big whitespace editor of Power BI is way WAY better than either of the Measure editors (yes 2 of them!) in Excel, which don’t properly support indent/outdent, intellisense gets in the way, too easy when tabbing to be in the formatting section vs just trying to indent, etc.
2. Ability to have bi-directional filtering on relationships
3. Ability to create calculated tables entirely in DAX – SUMMARIZE(), UNION(), INTERSECT(), etc.
4. Have existing DAX functions fully supported in model, intellisense, etc. Notably TREATAS()

Conditional Formatting it too small as well.

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))

I spend more time in Power Query than any other aspect of Excel. Love it!

No. If you use Power Query to bring it in, it can be CSV, TSV, TXT or any extension. As long as it is a text file, Power Query will allow you to keep it as text and keep leading zeros.