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 ,
Assuming that you have a Date Table.
Can you share some sample data and your Data Model
Regards,
Harsh Nathani
I don't have a date table there,I just have created a date and closed date for tickets and a unique Incident ID.
My data source is excel here, which i am sharing here.