I have date 04/21. How can I fix it to 01/04/2021?
Go to Solution.
Hi @ola210586 ，
Try like below:
Step1，change date type to date:
Step 2, use the following dax to create new date column:
datenew = DATE(YEAR('Table'[Date]),MONTH('Table'[Date]),01)
Final you will see the below:
And you could use the new column and delete before column then rename new column .
Wish it is helpful for you!
View solution in original post
Hi @ola210586 ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Thank you for your help
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.