Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

How to change YYYYMMDD into date format?

Hello guys,   How can i change the '20170104' from column IDT_DTM_ID into 04-01-2017?   Kind regards,   Rega  
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

No No,

 

u r trying to create in power Query window. so only it throws error.

 

i was gave u DAX Query.

 

U have to create new column in Development environment .

 

1. Create via Modelling Tab.

 

 

 

2. Right click on Table and choose new colum and apply the formula

 

 

Let me know if any help

 

 

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

for using data model, you need to use following expression when you add custom column

 

=Date.FromText(
Text.Range([Input Date as Sting], 0,4) & "-"  &
Text.Range([Input Date as Sting], 4,2) & "-" &
Text.Range([Input Date as Sting], 6,2)
)

More information here:

 

https://msdn.microsoft.com/en-us/library/mt260703.aspx