Problem with data

[Andioli]

Hi, 

I have a problem with the data in the column, it is showned as 1/2019 , 10/2019.. etc. How can I add a "0"and it becomes 01/2019, 02/2019..etc. Thank you!

[dufoq3 · Accepted solution]

Power Query solution:

Add this as new step, replace Source with your PreviousStepName and "Column1" with your column name you want to change.

= Table.TransformColumns(Source, {{"Column1", each Text.PadStart(_, 7, "0"), type text}})

DAX solution:

Create new calculated column, change Column1 to your column name.

CorrectDate = IF(LEN([Column1]) = 6, "0" & [Column1], [Column1])

[tharunkumarRTK · Accepted solution]

@Andioli 

Assuming you column data type is date, select the column and on top ribbon you will find different formattitng options and choose the appropriate one. For exmaple:

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[dufoq3 · Accepted solution]

Power Query solution:

Add this as new step, replace Source with your PreviousStepName and "Column1" with your column name you want to change.

= Table.TransformColumns(Source, {{"Column1", each Text.PadStart(_, 7, "0"), type text}})

DAX solution:

Create new calculated column, change Column1 to your column name.

CorrectDate = IF(LEN([Column1]) = 6, "0" & [Column1], [Column1])