Forum Discussion
How to solve two dates with the same Status Name
Hi Newbie here, I have this data and i want to pivot the Status to become the column and the status start date as their values however there are status that has two dates. How do I solve this so...
NewStep=Table.Pivot(PreviousStepName,List.Distinct(PrevousStepName[Status]),"Status","Status Start Date",List.Min)
wdx223_Daniel ,Hi - Thank you but it seems did not work, it captured the older dates
Pivoted
Original