Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

M Language - Filtered Sum from other table

Hello,

 

I have 2 tables in Power BI.

 

Table A with fields Agency_ID, Date, Payment

Table B with fields Agency_ID and X other fields.

 

I want a custom column Total_Paid in table B taht is the sum of Payment per Agency_ID without taking into account the Date.

 

How can I do it, please ?

 

Thanks

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    It may be easy with DAX to create a calculated column, could you accept this?

    What relationship between Table A and B?

    Does Agency_ID has duplicates values or distint values in Table A or B?

     

    Best Regards

    Maggie

     

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous

    It may be easy with DAX to create a calculated column, could you accept this?

    What relationship between Table A and B?

    Does Agency_ID has duplicates values or distint values in Table A or B?

     

    Best Regards

    Maggie