Error while sorting

[Anonymous]

Hi All,

  Need help for below error

I am trying to sort the column but it is giving below error.

any suggestions would be appreciated.

[v-chuncz-msft]

@Anonymous ,

It's obvious that the second column has more than one distinct value.

[Anonymous]

---

@v-chuncz-msft wrote:

It's obvious that the second column has more than one distinct value.

---

Yes,I do understand that there are multiple values in one column .Because We have applied If,else condition to display the Month-year which comes under range which displays  "NA",Date," month" values

I am looking for workaround or solution for this problem.

actually what I want to do is sort the data by month-year like Mar-2019 to mar-2018 and display data only for last one year.

[Anonymous]

Hi DAX_Learner07,

Your sorting column should be in integer/whole number. If it is text or in Date format, then it throws an error.

Regards,

Pradeep