I have two tables
Table 2: Loan Table with Created date of last two months: April and May
I want output in following format
|Admin_Name||Approved Loans Count||Leads Count||New Loan Count|
Logics to be used:
|Selected Date (Slicer)||Using||Lead_Created_Date||01/05/21||07/05/21|
|Approved Loans Count Logic||Count of LeadID from Loans Table if Funding_Amount>0 and Approve_Date is not blank and Approve_Date is between date selected in slicer|
|Leads Count Logic||Count of LeadID from Loans Table if Lead_Created_Date is between date selected in slicer|
|New Loan Count||Count of LeadID from Loans Table if Funding_Amount>0 and Approve_Date is not blank and Approve_Date is between date selected in slicer and Lead_Created_Date=Approve_Date|
Approved Loan Count should be basis Approved date(Approved date should be between date range selected in slicer)
Solved! Go to Solution.
There is some issue in this DAX
I want to filter
Count of loan approved basis Approve_Date
& Count of leads basis Lead_Created_Date
In Slicer, if I use Lead_Created_Date to select date range then only count of leads is showing correct
and if I use Approve_Date to select date range then only count of loans is showing correct
Not quite clear about your quesition. I think it will be better to use the date slicer from datetime table. not approve date or create date. Then use DAX to control the result based on approve date or create date.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!