Solved: Unable to sort a custom column created in Power BI

badri2008 · ‎09-22-2017

Unable to sort a custom column created in Power BI .

When i go to manage Query and Additional condition.

Iam getting the drop down for the columns in my sql table and not the custom column i created

Please help on sorting my custom cloumn

MarcelBeug · ‎09-24-2017

Probably you added a column in your datamodel (with DAX): such columns can't be refered to in Power Query, as Power Query always comes first and DAX second.

You can ad a column in Power Query and refer to it in either Power Query or DAX.

Specializing in Power Query Formula Language (M)

View solution in original post

v-chuncz-msft · ‎09-24-2017

@badri2008,

It seems to work for me. Share us more details to reproduce the issue.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MarcelBeug · ‎09-24-2017

Probably you added a column in your datamodel (with DAX): such columns can't be refered to in Power Query, as Power Query always comes first and DAX second.

You can ad a column in Power Query and refer to it in either Power Query or DAX.

Specializing in Power Query Formula Language (M)

Unable to sort a custom column created in Power BI

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly