Forum Discussion
Helper IVHow to sum value from 2 table without relation ?
Hello everyone, I have 2 table below :
Table 1 :
Table 2 :
I post a plib in that link :https://drive.google.com/file/d/1i_KvhMvTM1HVo95eszcauvlLFLG2FRj2/view?usp=sharing
How can I add the provinces in table 2 (Campus Code is Unspecified) respectively to table 1 (as same as Province Name) ? Can everyone help me a dax ?
Table 1 like :
9 Replies
- amitchandak
Super User
sakuragihana , You need to create common dimensions like Province Name, date tec
sakuragihanaHi amitchandak ,
I want to sum value from Table 2 that Campus Code is unspecified into Table 1 (respectively Province Name ) . I don't want to show Unspecified in the table 1
Table 1 like as :
Can you help me a dax ?
CNENFRNLCommunity Champion
Simple enough, use TREATAS() to create virtual relationship on the fly if the perfomance is not a big concern.
- sakuragihana
Hi CNENFRNL ,
I don't know how to use TREATAS , can you see the pibx I attached and help me
- sakuragihana
Hi CNENFRNL ,
Can you help me ?
- CNENFRNL
Paste well-prepared mock-up data first.
