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...
Anonymousmaybe i didn't understand you correctly, i created this calculation field under my "activity" table, but the DAX is invalid.
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