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]
    )

RSSILVA_22's avatar
RSSILVA_22
Helper I
4 years ago

did not work. He made the date -1 The expected was to bring the date of the previous registration.

 

 

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