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...
Thank you v-cherch-msft for this awesome solution!
How should I modify it in order to add more columns in the future based on the date?
So if my original table looked like this:
| ComID | UpdatedOutcomeDate | Outcome |
| 1 | 01/01/2017 | A |
| 1 | 03/01/2017 | B |
| 2 | 01/05/2018 | C |
| 3 | 04/05/2018 | A |
| 3 | 06/05/2018 | C |
| 1 | 01/01/2018 | G |
| 3 | 01/07/2018 | D |
| 3 | 01/10/2018 | F |
and I'd like to show it like this:
| ComID | UpdatedOutcomeDate1 | Outcome | UpdatedOutcomeDate2 | Outcome | UpdatedOutcomeDate3 | Outcome | UpdatedOutcomeDate4 | Outcome |
| 1 | 01/01/2017 | A | 03/01/2017 | B | 01/01/2018 | G | ||
| 2 | 01/05/2018 | C | ||||||
| 3 | 04/05/2018 | A | 06/05/2018 | C | 01/07/2018 | D | 01/10/2018 | F |
Hi kazael
It seems there is no better way to do that with DAX. Using M language in query editor is a more complex way to do that.
Regards,
Cherie