Forum Discussion
Solved
Transform a string into date (YYYY-MM) and order it properly
Hello my friends, I searched for solutions for my problem, but this is a bit different as i saw here, hope you can help me. Here i go: I have a column called "PeriodoLibro" where i have Year and...
Hi caito103,
Format your Year and Month column into numbers then add the following column:
Month_Name = FORMAT(DATE(Table3[YEAR],Table3[MONTH],1),"mmmm")
If you just add the formula below you will get a column with a date and then you can format as your want in your visuals.
DATE(Table3[YEAR],Table3[MONTH],1)
The result should be the one below:
Regards,
MFelix
Hi caito103,
Have you tried the solutions provided above? Do they work in your scenario? If the solution works could you accept it as answer to close this thread?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards
Yes, it works! Its already marked as solution, thanks for all to everyone, ever giving a hand :)
Best,