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 change...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

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

    [Column1] & "01"
HotChilli's avatar
HotChilli
Community Champion
6 years ago

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

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

    Ah brilliant - thankyou HotChilli 

     

    It wasnt set as text in power query. Thankyou!