Forum Discussion
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:...
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
v-piga-msft I don't have access for modelling the SQL database.
The measure looks legit, I will try on it. Thank you :)
=FORMAT('Date'[Date], "dd/mm/yyyy")*1
Hi,
Format doesn't work. Any idea? Below is the view pop up.
https://drive.google.com/file/d/19poSGC_YQfRr4fMfutQ5YDC9njGK4vtR/view?usp=sharing