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.), and my main table will have calculated columns to calculate 2016/17, 2017/18 etc. using multipliers from yet another table (I am tackling this part with LOOKUPVALUE). 

 

My question is how can I append the savings rows into my main table where there are exactly named columns (2016/17 etc.). I am happy to create a new table too, but I am unable to do that using UNION. 

 

Please let me know if you need any additional information.

Need Help

6 Replies

    • 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
        Microsoft 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,