Forum Discussion
Anonymous
6 years agoNot applicable
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
- HotChilliCommunity Champion
If the column is text (if it isn't then change it), you can use
[Column1] & "01"- AnonymousNot applicable