How can I get a column evaluating two other date columns?

[jmontes1810]

Hi community,
This time I need your help to create a column that helps to evaluate two factors, let me explain:

First, I need to detect whe a date is in more than one row in the column "Internal Due Date".
Like the case of Enrique & Aaron, or the case of Valerie, Javier & Khalef (blue and grey fileds)

Then, among these who have the same date in "Internal Due Date", evaluate who has the oldest date in "Date Requested" and put a text/identifier to the rest ones. In this case, "Push" in the column "Desired Column".

"Desired Column" is the one I want to get.

Hope you can help me soon, thnks in advance community.

Customer	Internal Due Date	Date Requested	Desired Column
Julia	10/21/2021	10/20/2021
Martin	10/29/2021	10/27/2021
Enrique	11/10/2021	10/28/2021	Push
Melissa	11/2/2021	11/1/2021
Gerard	11/8/2021	11/4/2021
Farid	11/9/2021	11/4/2021
Aaron	11/10/2021	11/10/2021
Samantha	11/11/2021	11/8/2021
Dan	11/12/2021	11/8/2021
Valerie	11/18/2021	11/11/2021
Javier	11/18/2021	11/17/2021	Push
Khalef	11/18/2021	11/17/2021	Push

[v-rongtiep-msft · Accepted solution]

Hi @jmontes1810 ,

It seems that the date "11/11/2021" is earlier than "11/17/2021". Please check.

Please have a try.

Create a measure.

Measure = var repeat_date=COUNTROWS(FILTER(ALL('Table'),'Table'[Internal Due Date]=SELECTEDVALUE('Table'[Internal Due Date])))
var grou= CALCULATE(MIN('Table'[Date Requested]),FILTER(ALL('Table'),'Table'[Internal Due Date]=SELECTEDVALUE('Table'[Internal Due Date])))
var aa= IF(repeat_date>=2&&grou=SELECTEDVALUE('Table'[Date Requested]),"Push",BLANK())
return aa

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.