Strip Date column data out to new column in PowerBI table

[cparke94]

Hi,

I have connected a SQL DB to PowerBI and I need to create a new Column called ImportDate on the table, in order to start building my dashboard and graphs. I want to Strip out the date part of CreateDate (highlighted below) from an existing column to populate ImportDate. Currently CreateDate has both the date and the time, I want ImportDate to only contain the Date part. Can you please advise me on what I need to do? Is there a SPLIT or Remove function that I could use?

   

[ccakjcrx]

@cparke94

Hey!

There was a seperate thread where this was solved. See the following link that offers different solutions for this problem: solution.

Regards!