Forum Discussion
Calculate Ticket SLA
Hi All, I’ve been requested to calculate the tickets SLA by adding all the open tickets and tickets closed in last 30 days. I have columns "Date closed" and "Ticket Status(inprogress, open, c...
Hi Pinky0404,
Looks like you have created a lot of calculated columns. Found a bracket is missing in one of your measures
2)Closed in LAst 30 days = IF((Footprint[Date Closed]> (Footprint[RD]-30)) && (Footprint[Date Closed]<=Footprint[RD]),"Closed 30 days","Null")
Can you share your pbix file, I'll be able to write a measure that does the same
Please share me your email id.