Sorting

[Anonymous]

Hi All,

I have some data fields in my dataset which I want to sort in an order.

I have created a calulated column for that but its giving me an error.

any help here?

Segments needed to sort:

Calculated column created:

While sorting getting this error

[rajulshah]

@Anonymous 

You cannot add calculated column for sorting using the same column that we need to sort. You would need to add the sorting column in the backend (datasource or power query) or can create calculated column not using the particular column (here, MARKET_SEGMENT).

[Anonymous · Accepted solution]

I created a custom table and then using Merge Queries got the desired result.

Thanks for the update though.

Regards