Forum Discussion

PPStar's avatar
PPStar
Helper 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
Resident 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
Helper 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
    Resident 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

    • PPStar's avatar
      PPStar
      Helper V
      2 years ago

      Thank you so much. That worked