cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Taking Difference between two columns in a Table Visual (Values from different tables)

Good Morning!

I feel a bit foolish having to ask this question however I am stumped. I have a table visual that I am trying to layer out a budget and then the actual amount spent per account # per period. There are two different tables (my actual spent and original budget tables). I have them connected via account numbers a Fiscal Period. 

 

I have them in a Table visual as such:

Before.png

 

I am trying to add a "$ Delta" and "% Delta" for the difference between the Budget Amount and Actual Spend. I have tried various measures however I am doing something wrong. Here is an example of one formula:

Formula.png

 

The problem is when i add this measure in it blows out the dataset. I can see one row where I see what I am looking for (framed in red) however a whole bunch of extra rows show up as well. 

Error.png

 

Thanks in advance! 

 

Dan

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Taking Difference between two columns in a Table Visual (Values from different tables)

@Icey  - thank you for your response. You are spot on and the issue is being caused by the relationship (or lack thereof). I actually went down the path of merging the two tables together into a new table and solved the issue that way. 

 

Dan

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Taking Difference between two columns in a Table Visual (Values from different tables)

Hi @danb ,

I make a sample. If your data structure is similar to mine,the measure you create is meaningless. Because the value of 'Budget Amount' is the whole 'Fiscal Period' and the value of 'Actual Spent' is the specific value of each 'Account Description'. They are not one-to-one correspondence in the Table visual. Then you can tell me what do you want to do, so that I can help you better.

Taking Difference between two columns in a Table Visual (Values from different tables) 2 .PNG

Best Regards,

Icey Zhang

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Resolver I
Resolver I

Re: Taking Difference between two columns in a Table Visual (Values from different tables)

@Icey  - thank you for your response. You are spot on and the issue is being caused by the relationship (or lack thereof). I actually went down the path of merging the two tables together into a new table and solved the issue that way. 

 

Dan

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors