Forum Discussion
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...
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?
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