cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
geejay Frequent Visitor
Frequent Visitor

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.

6 REPLIES 6
anithat Regular Visitor
Regular Visitor

Re: How to append queries to calculated columns

Hi @geejay

 

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

 

AppendQuery.png

geejay Frequent Visitor
Frequent Visitor

Re: How to append queries to calculated columns

That doesn't work with calculated columns as they don't show up on query editor.
Moderator v-sihou-msft
Moderator

Re: How to append queries to calculated columns

@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.

 

Capture888.PNG

Regards,

BI2B Frequent Visitor
Frequent Visitor

Re: How to append queries to calculated columns

@geejay

 

you could solve your problem?
I faced a similar

Cramos Frequent Visitor
Frequent Visitor

Re: How to append queries to calculated columns

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

BI2B Frequent Visitor
Frequent Visitor

Re: How to append queries to calculated columns

No,

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 398 members 3,336 guests
Please welcome our newest community members: