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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

You can add a calculated column to merge these data files, then use the new column to create the relationship.

 

Calculcate columns:

DateKey=  CONCATENATE([Year],[Month])

 

Calculate the %SavedPledge:

%SavedPledge= Table1[SavedPledge]/RELATED(Table2[CountCancelled])

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymousmaybe i didn't understand you correctly, i created this calculation field under my "activity" table, but the DAX is invalid. 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous,

       

      It seems like your table not direct contain the year and month fields, you can try to use Concatenate(Year([Datefield]),Month([Datefield])) to instead.

       

      If above still not help, can you share me a sample to test?

       

      Regards,

      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Anonymous thanks, i've created [DateKey] under Pledge table, but gave me below error message when i trying to relationship it with the "created on" date under Activity table. 

         

         

        how can i share the data with you here?