Forum Discussion

jmontes1810's avatar
jmontes1810
Frequent Visitor
4 years ago
Solved

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

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.

 

 

CustomerInternal Due DateDate RequestedDesired Column
Julia10/21/202110/20/2021 
Martin10/29/202110/27/2021 
Enrique11/10/202110/28/2021Push
Melissa11/2/202111/1/2021 
Gerard11/8/202111/4/2021 
Farid11/9/202111/4/2021 
Aaron11/10/202111/10/2021 
Samantha11/11/202111/8/2021 
Dan11/12/202111/8/2021 
Valerie11/18/202111/11/2021 
Javier11/18/202111/17/2021Push
Khalef11/18/202111/17/2021Push
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.