Skip to content

DAX Query output doesn't keep order of fields as you build and modify the query #1478

@edhans

Description

@edhans

Description

With 3.22.1, when you write a query, any changes to the query (new fields, extension columns, etc) are added to the end of the query output and not in the order of the query. You have to copy and paste the query to a new query window or close/reopen the query file.

Tabular Editor 3 Version

3.22.1

Screenshots

Here is the first query I wrote:

Image

I then modified it to include the Customer[Continent] field. It should be after Products[Brand] in the output, but it isn't. It is the far right of the query output.

Image

Same thing if I add more calculations. Here Units should be before Sales, but it is now the last column in the output.

Image

If I copy the query to a new window, I then get the columns in the order I want.

Image

Steps to Reproduce

  1. Write a query and run it
  2. add a column somewhere in the middle of the query and run it
  3. The columns in the output are not in the order you wrote them in the query.

Expected behavior

No response

Crash Report

No response

Windows Version

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    template: issueIssue report created by user, needs to be triaged

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions