Forum Discussion

corange's avatar
corange
Icon for Post Patron rankPost Patron
6 years ago

$value from one table to another

Hi everyone,   I am stuck with a probleme. The outcome I am trying to reach is to have the cumulative earnings YTD against the accumulated earnings target. The graph should update when changing the...
Need Help
corange's avatar
corange
Icon for Post Patron rankPost Patron
6 years ago

 Hi,

 

I am really new to POWER BI and trying this didnt work for me.

 

In table 1 I have got a same CODE multiple time with a dollar value associated to each. 

 

I would like in table 2 for BI to look for that same CODE and to add against that CODE the total value it obtained by sum up all the SAME CODE and their value from table 1.

 

I have tried using the RELATED () but it will not let me select the table I am after which one.

 

Any tips?  

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi corange ,

Can you please share some sample data and your expected results? Then we will understand your requirement clearly.

 

Please see this post regarding How to Get Your Question Answered Quickly: 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Xue Ding

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