Forum Discussion
bideveloper555
Helper IV
Helper IVPower bi pivot column
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 ...
bideveloper555 , Try to measure like this
statedate = maxx(filter(Table[state]="state"),Table[statedate])
ActiveDate= maxx(filter(Table[state]="active"),Table[statedate])
amitchandak
Super User
Super Userbideveloper555 , Try to measure like this
statedate = maxx(filter(Table[state]="state"),Table[statedate])
ActiveDate= maxx(filter(Table[state]="active"),Table[statedate])
bideveloper555Helper IV
Helper IVthank you amit.🍻
have a great day.