Power bi pivot column

[bideveloper555]

hi,

any help.

below is data

id	name	state	statedate
1	PS	intesting	15/06/2018
1	PS	active	10/06/2018

and i need to represent 

id	name	state	statedate	ActiveDate
1	PS	intesting	15/06/2018	10/06/2020

am trying to pivot one column which is when any data hold state as "active"i want "statedate" in same row.

or as below.

id	name	intestingdate	ActiveDate
1	PS	15/06/2018	10/06/2020

any solution.

thanks

[amitchandak · Accepted solution]

@bideveloper555 , Try to measure like this

statedate = maxx(filter(Table[state]="state"),Table[statedate])
ActiveDate= maxx(filter(Table[state]="active"),Table[statedate])

[bideveloper555]

thank you amit.🍻

have a great day.