I have two tables Overdue and Preclosure.
Now in Overdue table i want only the Loanno which not exists in Preclosue table for current month and year.
Go to Solution.
Try to filter the Preclosure Table first. Then use ‘Left Anti’ between Overdue table and Preclosure table.
You may try to use ‘Merge Queries’ with ‘Left Anti’ in Query Editor. Then you may filter the date with ‘Date Filters’ as below.
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?
The data will be shown as below picture. If it is not your case, please share some data sample and expected output.
Let us consider a sample
Loanno amount overduedate
1 1000 22-01-2018
2 550 11-05-2018
3 2500 12-08-2018
4 3222 12-08-2018
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).
Where is the Filter Rows option present.
You may find the "Custom Filter" to filter rows.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.