Forum Discussion
Excel Function To Dax Help
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
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.
2 Replies
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.
Thank you Pattem! This works great, will take note to post the data in copiable format in the future. Thank you!!
