Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

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.

Solution Sage
Solution Sage

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)






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

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.



Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors