CUSTOMER_NAMEOffer IdOFFERS_DATEOFFER_ACCEPTANCE_DATEREJECTION_DATEINVESTIGATION_DATESUBMISSION_TO_RISKSUBMISSION_DATE_TO_CREDITAPPROVAL_DATEClient 2113/02/2023 15/02/202314/02/202314/02/2023Client 3211/12/2023 12/03/202322/11/202324/12/2023Client 7309/06/202320/09/2023 22/08/202310/01/202324/09/202309/04/2023Client 9428/08/202330/08/2023 22/08/202309/05/202309/04/202309/04/2023Client 11504/03/202306/07/2023 06/07/2023 Client 12621/12/202317/01/2024 26/12/202320/02/202420/02/202419/02/2024Client 14704/10/202319/04/2023 04/09/202305/09/202324/05/2023 Client 15804/06/202304/06/2023 Client 18912/04/2023 12/05/2023 Client 201021/12/202318/01/2024 27/12/202322/01/202421/01/202421/01/2024Client 271109/01/202324/09/2023 09/10/202312/05/202312/04/202311/02/2023Client 311224/10/2023 12/04/2023 Client 321301/03/202322/01/2023 15/11/202214/02/202323/01/202320/01/2023Client 381416/11/2023 21/11/202321/11/202316/11/2023Client 431503/05/202303/05/2023 22/02/202303/05/202303/05/202303/06/2023Client 441609/03/202324/09/2023 09/11/202310/12/202310/02/202310/09/2023Client 491710/03/202310/03/2023 29/08/202311/08/202310/11/202310/11/2023Client 501809/01/202324/09/2023 24/08/202326/09/202326/09/202326/09/2023Client 511924/09/2023 11/12/202311/09/202326/09/2023Client 602010/10/2023 20/11/2023 10/10/202320/11/2023 I have all these dates To explain the situation i want to have dax or calculated column to give the below desired out put : 1- the total number of offers presented in specific period and this i can get it from the total offers date to COUNT it2- if the total number of offers in january equal 10 so i want something to see the last step that the offer is stpped on it so for example should be 2 at offering first stage 3 are pending accceptane 5 are under investigation that could happen when trackin the different dates of this offer

Romani let's nstart from point 1. which is the start date and end date of the period?The measure is:Total Offers in Period = VAR StartDate = DATE(2023, 1, 1) // Set your desired start dateVAR EndDate = DATE(2023, 12, 31) // Set your desired end dateRETURNCOUNTROWS ( FILTER ( YourTable, YourTable[OFFERS_DATE] >= StartDate && YourTable[OFFERS_DATE] <= EndDate ))you have to set the start date and end date. BBF

Romani perfect! please explain the second step better, with an examploe on data BBF

SummaryTotal Offers: 5Under Investigation: 1 (Client 11)Submission to Risk PhaseClients whose offers ended in this phase:Client 32Client 44Submission to Credit PhaseClients whose offers ended in this phase:Client 85Approval PhaseClients whose offers ended in this phase:Client 49So based above info when iam chossing this period give me this resultdid you get my point ?

Romani

Helper II

2 years ago

Generic date

CUSTOMER_NAME	Offer Id	OFFERS_DATE	OFFER_ACCEPTANCE_DATE	REJECTION_DATE	INVESTIGATION_DATE	SUBMISSION_TO_RISK	SUBMISSION_DATE_TO_CREDIT	APPROVAL_DATE
Client 2	1	13/02/2023				15/02/2023	14/02/2023	14/02/2023
Client 3	2	11/12/2023				12/03/2023	22/11/2023	24/12/2023
Client 7	3	09/06/2023	20/09/2023		22/08/2023	10/01/2023	24/09/2023	09/04/2023
Client 9	4	28/08/2023	30/08/2023		22/08/2023	09/05/2023	09/04/2023	09/04/2023
Client 11	5	04/03/2023	06/07/2023		06/07/2023
Client 12	6	21/12/2023	17/01/2024		26/12/2023	20/02/2024	20/02/2024	19/02/2024
Client 14	7	04/10/2023	19/04/2023		04/09/2023	05/09/2023	24/05/2023
Client 15	8	04/06/2023	04/06/2023
Client 18	9	12/04/2023			12/05/2023
Client 20	10	21/12/2023	18/01/2024		27/12/2023	22/01/2024	21/01/2024	21/01/2024
Client 27	11	09/01/2023	24/09/2023		09/10/2023	12/05/2023	12/04/2023	11/02/2023
Client 31	12	24/10/2023		12/04/2023
Client 32	13	01/03/2023	22/01/2023		15/11/2022	14/02/2023	23/01/2023	20/01/2023
Client 38	14	16/11/2023				21/11/2023	21/11/2023	16/11/2023
Client 43	15	03/05/2023	03/05/2023		22/02/2023	03/05/2023	03/05/2023	03/06/2023
Client 44	16	09/03/2023	24/09/2023		09/11/2023	10/12/2023	10/02/2023	10/09/2023
Client 49	17	10/03/2023	10/03/2023		29/08/2023	11/08/2023	10/11/2023	10/11/2023
Client 50	18	09/01/2023	24/09/2023		24/08/2023	26/09/2023	26/09/2023	26/09/2023
Client 51	19	24/09/2023				11/12/2023	11/09/2023	26/09/2023
Client 60	20	10/10/2023		20/11/2023		10/10/2023	20/11/2023

I have all these dates

To explain the situation i want to have dax or calculated column to give the below desired out put :

1- the total number of offers presented in specific period and this i can get it from the total offers date to COUNT it

2- if the total number of offers in january equal 10 so i want something to see the last step that the offer is stpped on it so for example should be 2 at offering first stage 3 are pending accceptane 5 are under investigation that could happen when trackin the different dates of this offer

Need Help

Forum Discussion

Generic date

10 Replies

Related content

Date Hierarchy does not get generated

Generate a column for dates between start dates (list/ pivot?)

Generating Missing Data

How to count open cases by selected date without generating all intermediate dates?

Generating link