Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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])
@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
@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
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])