Forum Discussion
bharukc
Helper I
Helper IPivot rows to columns
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 my result id active. Approved In review 1 2/1...
tamerj1
Community Champion
Community ChampionHi bharukc
use a matrix visual. Place the id in rows and status inn columns and measure: SELECTEDVALUE ( TableName[Date] ) in values
bharukcHelper I
Helper II need to create pivoted table so that I can make gantt chart to show how many days does it take for each milestone.
- tamerj1
You don't have to. You can calculate that without having you table pivotted. However, I have to say it might be easier to do the calculation while the table is pivoted.