Excel 365 for Windows is getting more functions only for Data Models with PowerPivot. Data Analysis Expression (DAX) functions are useful for exploring large datasets. There are a few UTC time/date functions we’d like to see made available to all Excel users.
A full list of the new DAX functions are below, two of those features caught our eye because they are functions users have wanted in Excel for many years.
The new DAX functions might be familiar to PowerBI users who already have these and more functions.
Getting UTC time in Excel
Getting the standard UTC time and date in Excel is important but not possible without some VBA. See Easy way to get UTC / GMT current time in Excel . Excel has NOW() and other functions which return the current date/time according to the current computer setting but no direct way to get the time independent of the computer location or setting.
It’s frustrating to see that the new DAX functions include two functions that return the UTC/GMT date or time, something that all Excel users deserve to have.
See also Get the local time zone offset into Excel a related omission from Excel’s in-built functions.
How about Microsoft make some UTC and UTC offset functions available to all Excel customers?
How to use DAX functions
Start with an Excel Data Model then go to Power Pivot | Measures | New Measure. Make a new measure with a formula that can include DAX functions.
Once that’s done, make a PivotTable from the same Data Model. In the PivotTable fields list will be the Measure/DAX function that you can drag into the PivotTable.
Who gets it?
To get the new DAX functions you need:
- Excel 365 for Windows
- With PowerPivot
- Originally only for Beta Channel users v 2208 build 15504.10000 or later.
In practice, the easiest way is to try using one of the new DAX functions to see if it’s available.
DAX function full list of new functions
Microsoft has a DAX function referencen, here’s a full list of the new functions.