Generate Year and Month Combinations in Power BI Report using DAX

[@richardcrump4786]

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!

[@Max.Vianna]

Thank you, my friend! You have no idea how much you actually helped me with this tutorial.

[@RADACAD]

Thanks. Glad it helped :)

[@AndiTMusik]

This took so much pain away from me!!! Thank you!!!

[@RADACAD]

Glad it helped!

[@nguyenthixuanhien2282]

Thank you for your clear guidance. It helps me a lot.

[@RADACAD]

You're most welcome!

[@filipwinski4219]

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!!!

[@RADACAD]

I am glad it helped Filip!

[@kandavel.v2827]

Excellent and simple solution

[@RADACAD]

Glad you like it

[@PallaviChauhan91]

Thank you for this helpful tutorial :)

[@hendrag1174]

Thanks Reza for this great video...

[@RADACAD]

My pleasure!

[@Mars7822]

Hey, thnks, easily explained concept.

[@RADACAD]

Most welcome!

[@mobinapatan1159]

Excellent.....thank you so much... this video solved my problem...plz continue posting video

[@RADACAD]

Happy to help

[@shreesonlinediary]

You are smart, thanks for sharing

[@RADACAD]

Thanks for watching!

[@happyexcel-ing]

Subscribed..just because you are problem solver

[@jorgearmandoglez]

Thank you, very clear and it helped me so much!!

[@mesaklewedalu9219]

how combine date, month and year with diffrent colmn to make one colmn date

[@GerardoGonzalez-g1y]

Thanks, very helpful

[@RADACAD]

You're welcome!

[@victorsales863]

The new column created "Year-Month" is in text format, so if I want to put this column data in a slicer, I can't use the relative date for visualizing the last 12 months for example, because the data type is text now. How Can I fix it?

[@reinds2044]

THANK YOU SO MUCH FOR THIS!

[@Ysorocks]

Thanks so much

[@RADACAD]

You're welcome!

[@abdulazim8276]

What about the formula if we use in direct query mode

[@RADACAD]

If you are using DirectQuery mode, then you can use SQL functions, depending on the source there are usually DATE FORMAT functions in database systems.

[@omotayogbadamosi4678]

Thank you!

[@jameszeng2666]

Three clicks in Tableau, and in Power BI I need 3 columns and tons of work ... just saying

[@unnikrishnansanthosh]

thank you for sharing