Forum Discussion
ServiceNow Ticket Analysis
Anonymous I don't mind doing goto meeting sessions but a bit busy for a few days, I would still recommend to post it here so that multiple community members can chime in provide the solution.
If you still want to do a goto meeting session, it is something I can do next week or so.
Anonymous you can surely do a similar calculation in Power BI but it is not straight forward translation. You need to share the sample data and expected output and then someone from the community will provide your relevant DAX formula for that.
A lot of stuff in Power BI goes in data modelling which leads to effective DAX measures to get the result, so there are few moving components.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
I can surely do that.
But I work on multiple sheets to will have to put in one at a time so that I can tell you what is to be done and what needs to be the outputs.
1. Open Vs Resolved tickets (Incidents, Tasks, etc) Created, Resolved and In-Progress
This is just one there almost 6-7 of them that have a different analysis.
I prefer having a go to meeting session to go through the same. Let me know if that works.