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]))

Anonymous's avatar
Anonymous
Not applicable
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]))