+ Reply to Thread
Results 1 to 4 of 4

DAX Date functions

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    610

    DAX Date functions

    Hello all,
    I've just started power query and Bi, and have followed a tutorial in which the expression '=# date( [year column], [pmonth column] , [day column]) was used, this did work, but I can't find it in the Microsoft DAX expressions on the Ignite site. Nor in the drop down list when entering.
    I tried some of the other 'date' functions that came up but they returned errors.
    Can someone please explain the # or direct me to where an explanation can be found.

    Thank you,
    Richard.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: DAX Date functions

    See if this helps

    https://docs.microsoft.com/en-us/pow...ction-hashtags
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    610

    Re: DAX Date functions

    Sorry no not really.

    Dicken

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: DAX Date functions

    Hi,

    That syntax isn't DAX, it's M.

    https://docs.microsoft.com/en-us/powerquery-m/sharpdate

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Date Functions
    By Topher53180 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-04-2013, 11:52 PM
  2. Help Returning The Week Day of a Date Without Using DATE and WEEKDAY Functions
    By vampirealexa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2013, 02:12 AM
  3. [SOLVED] Excel 2007 : Need help with using the date functions!
    By Rhuumz in forum Excel General
    Replies: 13
    Last Post: 06-12-2012, 12:30 AM
  4. about date functions
    By masterinex in forum Excel General
    Replies: 3
    Last Post: 10-17-2010, 04:43 AM
  5. IF and Date Functions
    By Christ4 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2006, 11:25 PM
  6. [SOLVED] Date Functions
    By KA Madrigal-Young in forum Excel General
    Replies: 1
    Last Post: 01-24-2006, 03:30 PM
  7. [SOLVED] date functions
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 6
    Last Post: 01-05-2006, 12:30 AM
  8. Date Functions
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2005, 01:03 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1