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.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps