Calculate ageing zero for next line where we are using end date as current date which is previous li

[RMtechm]

Hi Team,

need your help to resolve one query, working on below sample data,

requirement is for same id we have multiple line items, where we dont have end date need to use current date & after that line item all remaining line items ageing should be "0" even if we have end date for next line its ageing should be "0" for same ID.

output should be like this in "Created-Closed Days" (in closed date i have highlighted in green where have used current date):

Thanks in advance.

[JoeBarry]

Hi @RMtechm 

You can create a new column for Closed

ClosedNew = If(Table[Closed] = BLANK(), Today(), Table[Closed])

For the Created/Closed Days

IF ([ClosedNew] <= TODAY(), DATEDIFF(Table[CaseCreated], [ClosedNew], DAY), 0)

Thanks

Joe

If this post helps, then please Accept it as the solution

[RMtechm]

Hi Joe,

thanks for replay but it wont work as per requirement for current line item it is ok but what about next line item where i need "0" if we are using Closed date as Current date plz check out put table screenshot for your reference.

Note: you have taken same date for Created but my ask is same date for closed.

Thanks.