Forum Discussion
Show ticket progress status
Hi PBI community! I am trying to show service ticket status progress or change over time on a PBI report. I have a normalized table that looks like this: ComID UpdatedOutcomeDate Outcome 1...
Hi kazael
Could you expain more about your expected output? I cannot fully understand the third table. How do the First Status and Second Status and Count ComID come from ?
Regards,
Cherie
Sorry, you're right. It wasn't very clear.
I'm looking for a way to pivot the first table based on the date, so it will look like that:
| ComID | UpdatedOutcomeDate1 | Outcome | UpdatedOutcomeDate2 | Outcome |
| 1 | 01/01/2017 | A | 03/01/2017 | B |
| 2 | 01/05/2018 | C | ||
| 3 | 04/05/2018 | A | 06/05/2018 | C |
In addition, I'd like to add columns dynamically in case there are other outcomes and dates added to the same ComID.
Is it possible with DAX? Would it be better to push it to the DB and write it with SQL?
Thank you!