Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
RyanLau
Regular Visitor

How to transform the month(Jan, Feb, Mar...Dec) to a Date format

Hi,

 

My data has no date column and has a month column(Jan, Feb, Mar...Dec) and a year column respectively, can I transform it with DAX?

 

For example 

Month    Year

| Jan     |  2022|   --> 1/1/2022

 

Thanks

Ryan

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @RyanLau 

 

You can try the following methods.

Date = DATEVALUE('Table'[Year]&"/"&'Table'[Month]&"/"&"1")

vzhangti_0-1669965388119.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-zhangti
Community Support
Community Support

Hi, @RyanLau 

 

You can try the following methods.

Date = DATEVALUE('Table'[Year]&"/"&'Table'[Month]&"/"&"1")

vzhangti_0-1669965388119.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Charlotte,

 

It really works, many thanks!

 

Regards

Ryan

mh2587
Super User
Super User

combine date and year column then change the data type to Date


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.