cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Cannot add or subtract columns in power query after appending the data

Hello, Need urgent help. I have a table which is created by appending 3 different tables. Now I need to create a custom column using power query in which I need to add and subtract few columns to get the result.

e.g - consider 3 columns as Hub, MOT, Trade (each has data type decimal) I need to do calculation like Hub+MOT-Trade. But the result I am getting is only for Hub + MOT. 

Hub and MOT are appended from table Actual and MOT is appended from table Global

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Top Kudoed Authors
Users online (2,041)