How to get previous row

[UpharAnand]

Hi,

I wanto see the previous "Subscription Cancellation Date" . The thing is that I have multiple sourceid and I am unable to get the output.. Please see the below screenshot.

I want expected result as:

Just check the Subscription Cancelletion Date. in the excel sheet it is showing previous value for the sourceid.

Please help me.

I am attaching the power BI file

:https://drive.google.com/file/d/1onGdEpyBkffjbdg_OHNIrA-SKvWGjG4e/view?usp=drivesdk

[Anonymous · Accepted solution]

Thanks for the reply from @rajendraongole1 , please allow me to provide another insight:

Hi  @UpharAnand ,

There may be scenarios where both the top and bottom rows have the same date, resulting in the top row of the same date not being displayed, we can create an index to give each row a separate tag.

Here are the steps you can follow：

1. In Power Query -- add Column – Index Column – From 1.

2. Create calculated column.

Test =
MAXX(
    FILTER('Subscriptions',
    'Subscriptions'[Source Id]=EARLIER('Subscriptions'[Source Id])&&
  'Subscriptions'[Status]="Cancelled"&&
    'Subscriptions'[Index]<EARLIER('Subscriptions'[Index])),[Subscription Cancellation Date])

3. Result:

Best Regards,

Liu Yang

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

[rajendraongole1]

Hi @UpharAnand - Can you try the below calcuated column:

Previous Subscription Cancellation Date =
VAR CurrentSourceID = Subscriptions[sourceid]
VAR CurrentActivationDate = Subscriptions[Subscription Activation Date]
RETURN
CALCULATE(
MAX(Subscriptions[Subscription Cancellation Date]),
FILTER(
Subscriptions,
Subscriptions[sourceid] = CurrentSourceID &&
Subscriptions[Subscription Activation Date] < CurrentActivationDate
)
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!