Bug Hunting Session
Bug 96623 (DAX-Functions) - Add Data Analysis Expressions (DAX) functions to pivot table
Summary: Add Data Analysis Expressions (DAX) functions to pivot table
Status: NEW
Alias: DAX-Functions
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2015-12-20 13:48 UTC by Gerry
Modified: 2019-08-12 18:33 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 (retired) 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).