Forum Discussion

Rt123's avatar
Rt123
Frequent Visitor
5 years ago
Solved

Calculate total based on corresponding value in another table

Hi, I am trying to bring in total from one table based on the indirect values from another table,   Table1  Dates1  Dates2 25/04/2021 26/04/2020   Table2 (Data table) Dates1  Tot...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Rt123 

    You can create relationship between ‘Table1’[Dates2] and ‘Table2’[Dates1] , filter data from ‘Table1’ to ‘Table2’ , then create a measure to sum the value .

    I have attached my pbix file ,you can refer to it .

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Rt123 

You can create relationship between ‘Table1’[Dates2] and ‘Table2’[Dates1] , filter data from ‘Table1’ to ‘Table2’ , then create a measure to sum the value .

I have attached my pbix file ,you can refer to it .

 

Best Regards

Community Support Team _ Ailsa Tao

 

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

Rt123's avatar
Rt123
Frequent Visitor
5 years ago

Thank you Anonymous , it worked perfectly. Cant believe it was such simple solution..