Awesome!!! Thank you for sharing!!! I've immidiately replaced my old formula: = IF ( 'Calendar'[Month Number] < 10, 'Calendar'[Year] & "-0" & 'Calendar'[Month Number], 'Calendar'[Year] & "-" & 'Calendar'[Month Number] ) to your smooth function based on FORMAT. Have a nice weekend!!!
This took so much pain away from me!!! Thank you!!!
Glad it helped!
Thank you, my friend! You have no idea how much you actually helped me with this tutorial.
Thanks. Glad it helped :)
Thank you so much for posting this video. It solved a problem instantly for me that was causing a real headache! Your videos are extremely good!
Awesome!!! Thank you for sharing!!! I've immidiately replaced my old formula:
=
IF (
'Calendar'[Month Number] < 10,
'Calendar'[Year] & "-0" & 'Calendar'[Month Number],
'Calendar'[Year] & "-" & 'Calendar'[Month Number]
)
to your smooth function based on FORMAT. Have a nice weekend!!!
I am glad it helped Filip!
Excellent and simple solution
Glad you like it
What about the formula if we use in direct query mode
Subscribed..just because you are problem solver
thank you for sharing
how combine date, month and year with diffrent colmn to make one colmn date
Hey, thnks, easily explained concept.
Most welcome!
You are smart, thanks for sharing
Thanks for watching!
Thank you for this helpful tutorial :)
Excellent.....thank you so much...
this video solved my problem...plz continue posting video
Happy to help
Thanks Reza for this great video...
My pleasure!
Thank you, very clear and it helped me so much!!
THANK YOU SO MUCH FOR THIS!
Thanks, very helpful
You're welcome!
Thank you!
Three clicks in Tableau, and in Power BI I need 3 columns and tons of work ... just saying
Thanks so much
You're welcome!