Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
geejay
Regular 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
Resolver II
Resolver II

Hi @geejay

 

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

 

AppendQuery.png

That doesn't work with calculated columns as they don't show up on query editor.

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

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

BI2B
Frequent Visitor

No,

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

@geejay

 

you could solve your problem?
I faced a similar

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors