Forum Discussion

geejay's avatar
geejay
Regular Visitor
10 years ago

How to append queries to calculated columns

 Hello all,   I am stuck with a problem that I am really hoping someone can help me with.    I have savings data on a separate table (from query) (CostCentreID - 2015/16 - 2016/17 - 2017/18 etc.)...
Need Help
anithat's avatar
anithat
Icon for Resolver II rankResolver II
10 years ago

Hi geejay

 

Go to Edit Queries option on PBID, try using "Append Queries" option.

 

  • geejay's avatar
    geejay
    Regular Visitor
    10 years ago
    That doesn't work with calculated columns as they don't show up on query editor.
    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      geejay

       

      In Power BI Desktop, the calculated column will not be displayed in Query Editor. You can only add Custom Column within Query Editor and use it for appending queries.

       

      Regards,

      • Cramos's avatar
        Cramos
        Frequent Visitor
        9 years ago

        Hi, did you solve your problem? I'm also triying to append queries with calculated columns.