Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Combine/Concatenate

Hi,

 

I have a column of dates that are in the format e.g. 202003 as March 2020 etc that are either whole number or text.

 

Power BI doesnt seem to recognise these dates when I convert and changes it to 21/01/2453.

 

What I'm thinking is if I added 1 or 01 to the end of each date would it read it as a date okay, so 20200301 for the first of the month?

 

If so, how can I combine the date with 01 at the end using M and a custom column?

 

Thanks in advance for any help

 

Liam

 

  • If the column is text (if it isn't then change it), you can use

    [Column1] & "01"

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    If the column is text (if it isn't then change it), you can use

    [Column1] & "01"
    • Anonymous's avatar
      Anonymous
      Not applicable

      Ah brilliant - thankyou HotChilli 

       

      It wasnt set as text in power query. Thankyou!

  • Mariusz's avatar
    Mariusz
    Community Champion

    HI Anonymous 

     

    you can do the following

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn