Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Appending tables with calculated column

Hi,

 

In query editor when I try to append tables I see that Power BU ignores calculated columns? Please can you tell me how to append the calculated columns as well? Why does query editor ignore calculated columns?

 

Thanks,

 

CM

Need Help
  • ImkeF's avatar
    ImkeF
    9 years ago

    Query-editor -> Tab: Add Column -> General -> Custom Column

3 Replies

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    9 years ago

    If you do your "calculated columns" in the query editor instead of in the data model, you can append them in the query editor as well.

    Query editor -> data model is a one-way-street, so I'm always suggesting to do additional columns in the editor and use DAX just for measures.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      Hi Imke. Thanks - please can you tell me how to add a calculated column in the query editor? Thanks, CM
      • ImkeF's avatar
        ImkeF
        Icon for Community Champion rankCommunity Champion
        9 years ago

        Query-editor -> Tab: Add Column -> General -> Custom Column