Forum Discussion

RSSILVA_22's avatar
RSSILVA_22
Icon for Helper I rankHelper 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]
    )

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
Icon for Community Champion rankCommunity 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
    Icon for Helper I rankHelper 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