Forum Discussion

RSSILVA_22's avatar
RSSILVA_22
Helper I
4 years ago
Solved

calculated column help

I have the following table below:   the field "cod client" is repeated several times in the table. I need a column that shows the largest date, before the current record.   example: "cod d...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi RSSILVA_22 
    Here is the sample file withe workable solution https://www.dropbox.com/t/KT0CShGmy8yTXvEc

    Previous Date = 
VAR CurrentDate = pratic[date_value]
VAR CurrentClientTable =
    CALCULATETABLE ( pratic, ALLEXCEPT ( pratic, pratic[cod_client] ) )
RETURN
    MAXX (
        FILTER ( CurrentClientTable, pratic[date_value] < CurrentDate ),
        pratic[date_value]
    )

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi RSSILVA_22 
Here is the sample file withe workable solution https://www.dropbox.com/t/KT0CShGmy8yTXvEc

Previous Date = 
VAR CurrentDate = pratic[date_value]
VAR CurrentClientTable =
    CALCULATETABLE ( pratic, ALLEXCEPT ( pratic, pratic[cod_client] ) )
RETURN
    MAXX (
        FILTER ( CurrentClientTable, pratic[date_value] < CurrentDate ),
        pratic[date_value]
    )

rodrigo09062015's avatar
rodrigo09062015
Frequent Visitor
4 years ago

Hi tamerj1,

Thanks for your help.

Thank you for taking the time to review and respond.

It's good to have this community and people like you willing to help.

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    rodrigo09062015 
    Most welcome. I guess you are using two different user accounts. I was little confused 🙂
    If my reply satisfies your requirement, kindly consider marking it as acceptable solution.

    Have a great day!

    • RSSILVA_22's avatar
      RSSILVA_22
      Helper I
      4 years ago

      hello, that's why I wasn't finding the option to accept a solution. I was logging into the personal computer (user rodrigo09062015) and I forgot that I had posted on the company account.

      thanks