Forum Discussion

Narender's avatar
Narender
Icon for Resolver I rankResolver I
8 years ago
Solved

Create date from year-month field

Hi All,   I have a field in yyyy-mm (like 2018-01) format.   I need to create this field to complete date dd-mm-yyyy (like 12-01-2018). days can be any.   Please suggest me.     Thanks,   ...
Need Help
  • Narender's avatar
    Narender
    8 years ago

    I did this in power query . Convert date type -> date.It has added 01 day with each yyyy-mm field.

     

     

    Narender

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
8 years ago

Hi there if you go into Query Editor, you can add a new Columns from Examples and then put in what you want it to be as shown above.

 

If that does not work, you can add a Custom Column and put in the following:

 

"01-" & Text.End(Text.From([Column with yyyy-mm]),2) & "-" & Text.Start(Text.From([Column with yyyy-mm]),4)