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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Try Bi-directional join for passing filters across.

 

For YTD try

Year  = CALCULATE(SUM(table[column]),DATESYTD('Date'[Date Filer]))
Last Year  = CALCULATE(SUM(table[column]),DATESYTD(dateadd('Date'[Date Filer],-12,MONTH)))


Year Sales = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),('Date'[Date Filer])))
Lasr Year Sales = CALCULATE(TOTALYTD(sum(Sales[Sales Amount]),dateadd('Date'[Date Filer].-12,month)))

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

  • 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?