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

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