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

dujos's avatar
dujos
Icon for Helper I rankHelper I
7 years ago

Hello Hwang, see in the picture below the result.

IMPORTANT use a calculated Column to FORMAT DAX function works fine.

 

sorry the menus are in portuguese but i think you can identify the itens easy

and the date format fuction uses FORMAT(table[field];"mm/dd/yyyy")

 

Good Luck!!!

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Dujos,

 

The problem is i don't have access to the modelling tab, because its a company SQL BI cube.

I'm only able to modify the visual and and make DAX measure in the report.

 

I have tried above solution with FORMAT( 'Date'[Date],"dd/mm/yyyy)*1 but it also doesn't provide any result.