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,
Good Morning!
I have two tables Overdue and Preclosure.
Overdue:
Loanno
Overdueamount
EMI
OverdueDate
Preclosure:
Loanno
PreclosureDate
Now in Overdue table i want only the Loanno which not exists in Preclosue table for current month and year.
Regards,
Joshua.
Solved! Go to Solution.
Hi @Anonymous
Try to filter the Preclosure Table first. Then use ‘Left Anti’ between Overdue table and Preclosure table.
Regards,
Cherie
Hi @Anonymous
You may try to use ‘Merge Queries’ with ‘Left Anti’ in Query Editor. Then you may filter the date with ‘Date Filters’ as below.
Regards,
Cherie
Dear Cherie,
Thanks for ur reply.Will Left Anti (rows only in first) will show the data of overdue table for only loanno that not exists in preclosure table?
Regards,
Joshua.
Hi @Anonymous
The data will be shown as below picture. If it is not your case, please share some data sample and expected output.
Regards,
Cherie
Dear Cherie,
Let us consider a sample
Overdue:
Loanno amount overduedate
1 1000 22-01-2018
2 550 11-05-2018
3 2500 12-08-2018
4 3222 12-08-2018
Preclosure:
Loanno Preclosureamount Preclosuredate
3 2500 05-08-2018
Now i want to exclude the loano 3 in the overdue table as the amount was preclosed.It should work based on the condition where precloseddate=month(TodaysDate)&Year(TodaysDate).
Hi @Anonymous
Try to filter the Preclosure Table first. Then use ‘Left Anti’ between Overdue table and Preclosure table.
Regards,
Cherie
Dear Cherie,
Where is the Filter Rows option present.
Regards,
Joshua.
Hi @Anonymous
You may find the "Custom Filter" to filter rows.
Regards,
Cherie
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 |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |