Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
I want to create table based on fields from another tables.The following are the tables.
Billing Collection Overdue Bounce
Loankey, Loankey, Loankey, Loankey,
Loanno, Loanno, Loanno, Loanno,
branch, branch, branch, branch,
Monthyr Monthyr Monthyr Monthyr
Now i want to create a new table with only 4 fields from all tables.
Newtable
Loankey,
Loanno,
branch,
Monthyr
Regards,
Joshua.
Solved! Go to Solution.
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]))
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]))
Dear Seward ,
i will explain with an example
Billing:
Branch Loankey Loanno Monthyr amount
Bangalore 124Jun-18 124 Jun-18 2200
Collection:
Branch Loankey Loanno Monthyr amount
Bangalore 124Aug-18 124 Aug-18 1800
Now i want to create a new table
NewTable:
Branch Loankey Loanno Monthyr amount
Bangalore 124Jun-18 124 Jun-18 2200
Bangalore 124Aug-18 124 Aug-18 1800
Regards,
Joshua.
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.
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |