Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |