Which formula I can use to extract date from time stamp contains date & time?
Table looks like this on the table 'Date' [Date]
DAX being tried: DATE('Date'[Date]) --> no result.
Can brief me any easy fix for this?
Go to Solution.
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.
View solution in original post
@v-piga-msft I don't have access for modelling the SQL database.
The measure looks legit, I will try on it. Thank you 🙂
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")
Format doesn't work. Any idea? Below is the view pop up.
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.
Try this calculated column formula
Format this column as Date.
Hi Ashish & all experts here,
Thanks for all your advice, i guess i have to check on the source of my 'Date' [Date] table column, because in the formula, it has the red underlined.
Works for me.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!