Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |