Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Custom column help

Hi community   I know this might be a silly question, but I am currently facing this problem I can not solve. So, basically, I have these 2 tables, and what I need is to show the sum of $ from the ...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    Would you please refer to the following calculated column:

     

     

    Total Money = CALCULATE(SUM(Money Table[Money]),FILTER(Money Table,Money Table[Quarter] = EARLIER(Master Table[Quarter])&& Money Table[Region] = EARLIER(Master Table[Region]) && Money Table[Review Type] = EARLIER(Master Table[Review Type])))

     

     

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

     

    Best Regards,

    Dedmon Dai

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Would you please refer to the following calculated column:

     

     

    Total Money = CALCULATE(SUM(Money Table[Money]),FILTER(Money Table,Money Table[Quarter] = EARLIER(Master Table[Quarter])&& Money Table[Region] = EARLIER(Master Table[Region]) && Money Table[Review Type] = EARLIER(Master Table[Review Type])))

     

     

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

     

    Best Regards,

    Dedmon Dai

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks a lot Dedmon. You rock!!