Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Creating a table based on fields from another tables

Dear all,   I want to create table based on fields from another tables.The following are the tables.   Billing              Collection        Overdue           Bounce Loankey,           Loankey,...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Table = UNION(SUMMARIZE(Billing,Billing[Account No],Billing[Key],Billing[Amount ],Billing[MonthYr ],Billing[Flag]),

    SUMMARIZE(Bounce,Bounce[Account No],Bounce[Key],Bounce[Amount],Bounce[MonthYr],Bounce[Flag]),

    SUMMARIZE(Collection,Collection[AccountNo],Collection[key],Collection[Total],Collection[MonthYr],Collection[Flag]),

    SUMMARIZE(Overdue,Overdue[AccountNo],Overdue[key],Overdue[OVERDUEAmount],Overdue[MonthYr],Overdue[Flag]),

    SUMMARIZE(Register,Register[AccountNo],Register[key],Register[PRINCIPALAMOUNT ],Register[MonthYr ],Register[Flag]))

Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago
Create Table from Modeling tab.

New table = VALUES(billing[ColName])
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dear Seward,

 

Thanks for ur reply.

New table =VALUES(billing[Loankey],overdue[Loankey],bounce[Loankey],collection[Loankey])

will it works because the Loankey in New table must contain data loankey of all four tables.