topic Re: calculated column help in DAX Commands and Tips

calculated column help

RSSILVA_22 — Mon, 11 Apr 2022 16:48:50 GMT

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 de cliente" AAAAAAA tem o último registro com a data 2022-04-11. The next column should show the date 2022-03-05. In this record (2022-03-05) must be the largest datan before it. if there is no previous record show empty.

If anyone can help, I'd be grateful.

https://drive.google.com/file/d/1HRYhWWKty2YUXNPYnYb_YPZlFbx8sMa7/view?usp=sharing

Re: calculated column help

tamerj1 — Mon, 11 Apr 2022 17:34:09 GMT

Hi RSSILVA_22

you can try

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

Re: calculated column help

RSSILVA_22 — Mon, 11 Apr 2022 22:14:35 GMT

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

Re: calculated column help

tamerj1 — Tue, 12 Apr 2022 02:05:52 GMT

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

Re: calculated column help

rodrigo09062015 — Tue, 12 Apr 2022 02:57:03 GMT

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.

Re: calculated column help

tamerj1 — Tue, 12 Apr 2022 03:31:59 GMT

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!

Re: calculated column help

RSSILVA_22 — Tue, 12 Apr 2022 03:40:21 GMT

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