topic Re: Pivot rows to columns multiple dates for same status in DAX Commands and Tips

Pivot rows to columns multiple dates for same status

bharukc — Tue, 07 Jun 2022 16:23:25 GMT

My data is like below

id. Status. Status date

1. Active. 2/14/18

1. Approved 2/15/17

1. In review 2/19/18

1. Active. 3/15/19

2. Active. 2/15/19

2. Approved. 3/19/19

2 Approved. 4/19/19

my result

id active. Approved In review active. Approved

1 2/14/18. 2/15/17. 2/19/18. 3/15/19

2 2/15/19. 3/19/19. Null. Null. 4/19/19

tamerj1 — Tue, 07 Jun 2022 17:20:14 GMT

Can't you use a matrix visual?

bharukc — Tue, 07 Jun 2022 18:19:15 GMT

i want to creat gantt chart and use that layout for other calculations. I need it to be pivoted.