Bug 96623 (DAX-Functions)

Summary:	Add Data Analysis Expressions (DAX) functions to pivot table
Product:	LibreOffice	Reporter:	Gerry <gerry.treppel>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	erack, ilmari.lauhakangas, winfrieddonkers
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=94635
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108827

Description Gerry 2015-12-20 13:48:24 UTC

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.

Comment 1 Gerry 2015-12-24 12:11:05 UTC

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

Comment 2 Buovjaga 2015-12-27 16:46:50 UTC

Sounds good -> NEW.

Comment 3 Winfried Donkers 2015-12-28 07:13:02 UTC

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

Comment 4 gmolleda 2022-11-05 13:36:59 UTC

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.