Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX - Extract Date from TimeStamp (contain date & time)

Dear Experts,   Which formula I can use to extract date from time stamp contains date & time?   Table looks like this on the table 'Date' [Date]   Date 1/1/2018 12:00:00AM   DAX being tried:...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    Please check what data type of your Date column firstly.

     

    If your Date column is Date/Time type in Power BI, you only need to change the Data format to be M/d/yyyy under Modeling.

     

     

    If your Date column is Text type in Power BI, you could create the measure with the fomula below.

     

    Measure 2 = LEFT(MAX('Table2'[Date]),9)

    Here is the result.

     

     

    Best Regards,

    Cherry

  • Anonymous's avatar
    Anonymous
    7 years ago

    v-piga-msft I don't have access for modelling the SQL database.

     

    The measure looks legit, I will try on it. Thank you :)

nadavsn's avatar
nadavsn
Icon for Advocate I rankAdvocate I
7 years ago

try [DateTime].Date

Works for me.

Manuel-Levo's avatar
Manuel-Levo
Regular Visitor
4 years ago

I know this is an old answer, but this is only calling the related/hidden date column which is not really suggested.