Error While sorting a date column with Yearmonth

[unknown_anony]

Hello
I am unable to sort the date column with the Yearmonth Custom column. getting this below error. 

Please Suggest 
Thank you

[unknown_anony]

Thank you

[Daniel29195]

@unknown_anony 

you need to create a column where the each value in approveddate have one and only value in the order column ,

and 1 value in the order column is to one a only one value of the approved date 

ex : 

col1       order

jan 22      1 

jan 22      1

jan 22      1

feb 22      2

feb22      2 

i would suggest you create this column in power query . 

hope this helps 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[audreygerred · Accepted solution]

Hi! In order to sort Approved Date, you will need a column that has the same value for monthyear. In your data YearMonthNo has different values for each row. So, for Jan 22 of approved date you would need a column that signifies that this is 1 (for example, you could make a column that has 1/1/2022 for everything that is Jan 22, 2/1/2022 for everything that is Feb 22, etc.).