Forum Discussion

bideveloper555's avatar
bideveloper555
Helper IV
6 years ago
Solved

Power 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 ...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    bideveloper555 , Try to measure like this

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

amitchandak's avatar
amitchandak
Super User
6 years ago

bideveloper555 , Try to measure like this

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

bideveloper555's avatar
bideveloper555
Helper IV
6 years ago

thank you amit.🍻

have a great day.