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,

 

Try to create a table which contain the unique value, then create the relationship between above table and the new table.

 

Table = DISTINCT(UNION(VALUES(Table1[DateKey]),VALUES(Table2[DateKey])))

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous still same error.  how can I attach data to you here?  15% is correct, but rest month % is all wrong. 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous how can i upload the data here?  thanks.  

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous,

       

      You can upload to 1dv and share us a link.


      Regards,

      Xiaoxin Sheng