Forum Discussion

PPStar's avatar
PPStar
Icon for Helper V rankHelper V
2 years ago
Solved

Format Date Column

Hello.  I have a dataflow in the power BI Service. There is a date column (Date) which needs to be as a text data type (dont ask why) and needs to be in a specific format.  Currently the date colum...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Try this: Table.TransformColumns(Navigation, {{"YYYY-MM-DD", each Date.ToText(_, "yyyy-MM-dd"), type text}}) and see if this solves your problem

_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Yes it's possible. Please try this:

Table.TransformColumns(Navigation, {[#"Date"], each Date.ToText(_, "yyyy-MM-dd")})

Instead of "Table.AddColumn(Navigation, "Custom", each Date.ToText([#"Date"], "yyyy-MM-dd"))"

 

PPStar's avatar
PPStar
Icon for Helper V rankHelper V
2 years ago

Whilst visually, this looks correct, i just tried it and it gives me this error : 

 

Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?

Details
Reason = Expression.Error
 
Any ideas
  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    I use tha name of my column Date where I want to transform.
    Probably the error is on the [#"Date"]. Replace this column name for your column date name.

     

    • PPStar's avatar
      PPStar
      Icon for Helper V rankHelper V
      2 years ago

      I did that. My date column is called Y-M-D.

       

      This is the code i am using 

       

       #"Custom Column" = Table.TransformColumns(Navigation, {[#"Y-M-D"], each Date.ToText(_, "yyyy-MM-dd")})
      • _AAndrade's avatar
        _AAndrade
        Icon for Resident Rockstar rankResident Rockstar
        2 years ago

        Try this: Table.TransformColumns(Navigation, {{"YYYY-MM-DD", each Date.ToText(_, "yyyy-MM-dd"), type text}}) and see if this solves your problem