Excel 2016 introduced 25 new Data Analysis Expressions (DAX) functions: ADDMISSINGITEMS CALENDAR CALENDARAUTO CONCATENATEX DATEDIFF GEOMEAN GEOMEANX GROUPBY ISEMPTY ISONORAFTER MEDIAN MEDIANX NATURALINNERJOIN NATURALLEFTOUTERJOIN PERCENTILE.EXC PERCENTILE.INC PERCENTILEX.EXC PERCENTILEX.INC PRODUCT PRODUCTX SUBSTITUTEWITHINDEX SUMMARIZECOLUMNS UNION XIRR XNPV See: https://support.office.com/en-us/article/New-DAX-functions-8192a787-aa91-4d7f-9a82-4e2c607e629a I don't know whether all these functions are new to LibreOffice Calc, but some for sure.
Being a bit confused that Microsoft labels these 25 functions as "new" in Office 2016, I cross-checked their existence in LibreOffice. Currently not existing in LibreOffice: ADDMISSINGITEMS CALENDAR CALENDARAUTO CONCATENATEX (but CONCATENATE) DATEDIFF GEOMEANX GROUPBY ISEMPTY ISONORAFTER MEDIANX NATURALINNERJOIN NATURALLEFTOUTERJOIN PERCENTILEX.EXC PERCENTILEX.INC PRODUCTX SUBSTITUTEWITHINDEX SUMMARIZECOLUMNS UNION Existing in Calc (but unclear whether MS extended these function in Excel 2016) GEOMEAN MEDIAN PERCENTILE.EXC PERCENTILE.INC PRODUCT XIRR XNPV
Sounds good -> NEW.
Changed the summary as Excel2016 has these functions added to its 'power pivot', which is an add-in for Excel. That may explain the confusion of function being 'new'. AFAIK the only functions added to Excel 2016 'core' are the FORECAST.ETS functions (https://bugs.documentfoundation.org/show_bug.cgi?id=94635).
Just as Microsoft Office bought Power Pivot and being an application different from Excel, they have made a plugin that facilitates its integration (it makes it easier to add tables to the data model), in the same way LibreOffice could create a plugin that would facilitate the use of LinceBI. as possible.