Excel Blog
Home
Options
277
Steve Kraynak on 10-22-2018 11:33 AM
829
MS Excel Team on 10-15-2018 01:05 PM
1,812
Maha Alam on 09-27-2018 04:39 PM
14.3K
Joe McDaid on 09-25-2018 06:00 AM
10.3K
Prash Shirolkar on 09-25-2018 06:00 AM
1,891
MS Excel Team on 09-18-2018 10:06 AM
1,218
Blake T Walsh on 09-14-2018 11:54 AM
2,667
Blake T Walsh on 08-23-2018 03:30 PM
3,997
Blake T Walsh on 08-15-2018 12:11 PM
5,237
Kasper Langmann on 08-07-2018 11:41 AM
2,602
Microsoft Excel on 07-26-2018 10:50 AM
4,518
Blake T Walsh on 07-17-2018 06:15 PM
5,401
Guy Hunkin on 07-16-2018 07:29 AM
1,049
Blake T Walsh on 06-25-2018 01:23 PM
1,986
Blake T Walsh on 06-18-2018 03:43 PM
59K
Michael Molyneaux on 06-01-2018 08:30 AM
4,054
Johnnie Thomas on 05-10-2018 05:49 AM
1,547
Blake T Walsh on 05-08-2018 04:12 PM
1,183
Blake T Walsh on 04-23-2018 09:25 AM
3,787
Sangeeta Mudnal on 04-10-2018 11:50 AM
26.4K
John Campbell on 03-29-2018 09:00 AM
3,037
Maha Alam on 03-12-2018 05:57 PM
10.2K
Gregory Appel on 03-04-2018 04:16 AM
3,603
Guy Hunkin on 02-20-2018 08:39 AM
1,253
Blake T Walsh on 02-13-2018 04:12 PM
21.9K
Olaf Hubel on 01-23-2018 12:02 PM
6,700
Guy Hunkin on 01-18-2018 07:49 AM
1,604
Blake T Walsh on 01-17-2018 03:55 PM
3,608
Olaf Hubel on 01-02-2018 03:16 PM
Latest Comments
Partially @Miguel Ulloa - In your Power BI portal, click the download arrow in the upper right, then "Analyze in Excel Updates." It will guide you to a download that will install a set of files on your PC that will allow Excel to connect directly to your Power BI reports. It honors row level securit...
0 Likes
@Ed Hansberry Is this enabled by the "Power BI publisher" thing I just found?
0 Likes
@Ed Hansberry Thanks for your reply Ed. Both Power BI and Power Pivot include the username() function. In Power BI, I can use it in a DAX function that limits what the user sees, regardless of what's present in the file. How it works in in Power BI is exactly how I'd like it to work. If it needs the...
0 Likes
@erol sinan zorlu - You can see here what is new in Excel 2019 over 2016. The Dynamic Array functions will no doubt be in the next version of Excel (2022 or whatever) but right now it isn't even in Office 365 yet, just insider builds. That is the problem with the perpetual license. You get what you ...
0 Likes
Well I was expecting Excel 2019 would be a massive step forward however missing these dynamic array formulas it seems to be a face lift of 2016. It is a pity to hear also there is no plan on implementing this function to it. I am very dissapointed right now and see no reason to upgrade it from 2016.
0 Likes