Forum Discussion

bideveloper555's avatar
bideveloper555
Helper IV
6 years ago
Solved

Power bi pivot column

hi,

any help.

below is data

idnamestatestatedate
1PSintesting15/06/2018
1PSactive10/06/2018

and i need to represent 

idnamestatestatedateActiveDate
1PSintesting15/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.

idnameintestingdateActiveDate
1PS15/06/2018

10/06/2020

 

any solution.

 

thanks

 

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])

2 Replies

  • 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])