Previous date in Calculated column

[jaltoft]

Hello,

I have some data in which I have brought back MAX visit dates from a SQL database into powerBI. Column a which would be report week so all the data is in a is marked the same date. Column B is the client id. Column C is the Maximum visit date of each client, each client can possibly be visited more than once in a week.

I want to build a custom column to allow me to show the previous visit date to the maximum date in column C.

Can anyone help me on how to do this?

Thanks all

[jaltoft · Accepted solution]

Column A Column B Column C Desired output
13/12/2020 15616 12/12/2020 09/12/2020
13/12/2020 16515 10/12/2020 10/12/2020
13/12/2020 15688 10/12/2020 10/12/2020
13/12/2020 11111 09/12/2020 08/12/2020
13/12/2020 15616 09/12/2020 09/12/2020
13/12/2020 11111 08/12/2020 08/12/2020

I hope this helps? @HotChilli

[jaltoft]

Perfect, thanks @RicoZhou

[HotChilli]

Can you provide a small data sample (not a picture) please and show the desired output?

I'm sure someone can help

[jaltoft · Accepted solution]

Column A Column B Column C Desired output
13/12/2020 15616 12/12/2020 09/12/2020
13/12/2020 16515 10/12/2020 10/12/2020
13/12/2020 15688 10/12/2020 10/12/2020
13/12/2020 11111 09/12/2020 08/12/2020
13/12/2020 15616 09/12/2020 09/12/2020
13/12/2020 11111 08/12/2020 08/12/2020

I hope this helps? @HotChilli

[v-rzhou-msft · Accepted solution]

Hi @jaltoft 

I use your sample to have a test.

Calculated column:

Previous date = MINX(FILTER('Table','Table'[Column B]=EARLIER('Table'[Column B])),'Table'[Column C ])

Result is as below.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.