Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Calculation between 2 tables

I need to calculate % between 2 different tables, their "date" field is different.   it's end up with correct in "total" but wrong in "monthes" Those 2 tables have 2 different date fields (t...
Need Help
parry2k's avatar
parry2k
Super User
9 years ago

Can you confirm if I understood relation between your tables correctly:

 

- Contact Table is related to Activity table on contact id 

- Contact Table is related to pledge table on contact id

 

To calculate % by month, which date you want to use for month, Created on in Activity table or End Date in Pledge Table?

 

Also can you confirm if Saved Pledge and Count Cancelled are calculated measure, if yes, can you share their formulas?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

"SavedPledge" is a "new Measure" in Activity table

SavedPledge = calculate(counta('Activity - Phone Calls'[Result]),'Activity - Phone Calls'[Result]="Saved Pledge")

 

 

"CountCancelled" is a "new measure" in Pledge table

CountCancelled = calculate(counta('Pledge - Rejects and Cancels'[Pledge Status]),'Pledge - Rejects and Cancels'[Pledge Status]="Cancelled")

 

those 3 tables are connected by "Contact ID"

Activity table

Contacts table

Pledge table

 

"To calculate % by month, which date you want to use for month, Created on in Activity table or End Date in Pledge Table?" 

actually i tried on both, but all not working.