Forum Discussion
Tickets Backlog Calculation through DAX
Based on the first 3 columns(Image Attached), I am calculating Backlog for each day in excel, now I am moving to Power BI and new here. Using DAX how can I calculate Backlog from the first 3 column...
Hi rohitchouhan ,
Backlog =
var ClosedTckts = CALCULATE(COUNT('Table'[Close Date]),USERELATIONSHIP('Date'[Date],'Table'[Close Date]))
var OpenTckts= CALCULATE(COUNT('Table'[Open Date]),USERELATIONSHIP('Date'[Date],'Table'[Open Date]))
var Difference = ClosedTckts - OpenTckts
var Cumulative = FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date]))
var Backlog = CALCULATE(
SUMX('Date', Difference),
Cumulative)
return
Backlog
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Anonymous Hello sir, thanks for reply
what to to put here in place of ('Date'[Date],
kindly help