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 have the following 4 transaction tables
Billing Collection Overdue Bounce
Loankey, Loankey, Loankey, Loankey,
Loanno, Loanno, Loanno, Loanno,
branch, branch, branch, branch,
Monthyr Monthyr Monthyr Monthyr
Two master tables
BranchMaster
Branch
LoanMaster
Loankey,
Loanno,
branch,
Monthyr,
customername,
Disbursementamount,
EMI amount,
Approvedby
and one calendar table
Calendar
Monthyr
what kind of datamodel technique i have to use?
Regards,
Joshua.
Solved! Go to Solution.
Concatenate all Transational tables as 1 Table with a flag in each to identify them.
Then Link it with master Table and Calender table for association.
Concatenate all Transational tables as 1 Table with a flag in each to identify them.
Then Link it with master Table and Calender table for association.
Dear Erika,
I have appended the transanction tables into one still the tables are visible in datamodel.Is it Ok?
Please see the screenshot
Yes...You can also Hide them in Report View to avoid confusion.
Dear Erika ,
I have appended 4 transaction tables but data is loaded only for 1st table.Flag is available only for first table.
This sould not be the case.
Can you share your file with us or dummy data ?
Please send me ur email id.I will share the file.
erikajain02@gmail.com
Dear Erika,
I have sent the sample.
I have created a link table with the fields (AccountNo,Amount,MonthYr,Flag,Key)from the tables Register,Billing,Bounce,Overdue,Collection .And then I have connected the link table with Register , Billing,Bounce,Overdue,Collection with Key and Link table to the calendar with MonthYr.
Dear Erika,
While appending the same column names repeating. Here the column Amount repeats again.
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 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |