DAX - whole number month and year to date format

[Anonymous]

I have columns that are month and year as whole numbers ...so year is 2022, month is 1,2,3, etc.  

I would like to have those columns merge and display as Jan-22, Feb-22, Mar-22, etc

I've tried playing with formatting and switching things to dates but can't quite get there. 

Does anyone know what I should be doing to get that result?

[WinterMist]

Hello @Anonymous 

If either reply from @selinaz or myself was helpful, please consider marking them as solutions.

If there is something more that you need, please let us know.

Regards,

Nathan

[selinaz · Accepted solution]

Hi @Anonymous ，

Is this result you want to achieve?

I used power query to complete this process.
Refer to the following steps：

1.transform the type of two cloumns to "Text"

2.duplicate the "Year" column

3.Check this column and select “split column”---"by number of characters", then delete left column

4.choose "add column"---"custom column"

5.write this sytnax:

[Month]&"-"&[#"Year - Copy.2"]

6.finally you can get the result.

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

Best regards.

[WinterMist]

@Anonymous 

1) Create a new table for Months as follows:

2) Create a 1:* relationship between the 2 tables as follows:

3) Create a new calculated column in the 'Data' table as follows:

Regards,

Nathan