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

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