Excel Function To Dax Help

[Benjamin_chee]

Hi PowerBi Community,

I will like to create a custom column in PowerBI that follows a function I have created in excel. The function is on the column "Number of Records" in excel. Basically taking the (sum of all issues created till that date)- (the sum of issues resolved till that day).

Need help in creating the DAX formula in powerbi. Thank you! 

End result in Excel:

Formula in Excel:

Current PowerBI layout

[PattemManohar · Accepted solution]

@Benjamin_chee  Please try below.

Create a new column which will be a supporting column for the main logic.

TotalIssues = Test222Lkp[IssuesCreated]-Test222Lkp[IssuesResolved]

Then, create a new column which is your expected output 

NumOfRecords = CALCULATE(SUM(Test222Lkp[TotalIssues]),FILTER(Test222Lkp,Test222Lkp[DateCreated]<=EARLIER(Test222Lkp[DateCreated])))

Note - Please try to post the sample data in copiable format which will be great in time saving.

[Benjamin_chee]

Thank you Pattem! This works great, will take note to post the data in copiable format in the future. Thank you!!