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. 

      • BI2B's avatar
        BI2B
        Frequent Visitor
        9 years ago

        No,

        One solution
        rewrite the formula dax  in the language m
        I'll create a new topic

    • BI2B's avatar
      BI2B
      Frequent Visitor
      9 years ago

      @geejay

       

      you could solve your problem?
      I faced a similar