Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@bideveloper555 , Try to measure like this
statedate = maxx(filter(Table[state]="state"),Table[statedate])
ActiveDate= maxx(filter(Table[state]="active"),Table[statedate])
@bideveloper555 , Try to measure like this
statedate = maxx(filter(Table[state]="state"),Table[statedate])
ActiveDate= maxx(filter(Table[state]="active"),Table[statedate])
thank you amit.🍻
have a great day.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |