Error when converting a month name to month number

[nuttybuddy]

Hi guys

I need to sort my month name in the date order and not on alphabatical order so I was trying to add a new column based on month name which will give me the month no..

Here is my formula..

Month_Number = Month('Table1'[month_name])

This is the error I get below...

A single value for column 'master renewal month' in table 'Full list' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

Please help!!

[v-shex-msft · Accepted solution]

Hi @nuttybuddy,

I don't think you can directly convert month name to number, maybe you can try to use datevalue function to transfer them to date, then use month function to get month number.

Sample:

MonthNum = MONTH(DATEVALUE('Table'[Month Name]&"/1")) 

BTW, it seems like you are try to input calculated column formula into a measure, right?

Regards,

Xiaoxin Sheng

[vamsi1]

Hi @v-shex-msft

When i tried this function in my chart it is popping as "Cannot convert value '/1' of type Text to type Date." can you please help

Thanks

Vamsi

[Phil_Seamark]

HI @nuttybuddy

Do you have another column in the same table that is a DateTime value that matches the same month?