Forum Discussion
Shifting values from multiple rows to one row for Unique ID...
I'm using Power BI connecting to Salesforce to access the Opportunity Field History object (table). I'd like to end up with each stage an opportunity hits, in order, on a single row so I can then bu...
parry2k so i got the rank down, but now producing the columns so they show in one singular row appears to be an issue. I'm using an IF statement to grab each stage and the rank is based on the date the stage changed:
Stage1 = if( [StageRank] = 1, [OldValue])
Stage2 = if( [StageRank] = 1, [NewValue])
Stage3 = if( [StageRank] = 2, [OldValue])
It results in the following
| OppID | Rank | Stage1 | Stage2 | Stage3 |
| ABC123 | 1 | Prospecting | Qualifying | |
| ABC123 | 2 | Estimating |
Even when i remove the rank field from the table visual it still displays like the above. Any ideas as to how to get everything on the same row? Should I use something besides an IF statement?
Thanks!
parry2k
Super User
Super UserAnonymous hmmm, I think you should be a calculation to tag Stage 1 or 2 or 3..., it is like category with stage 1, 2, 3 values in it based on your rank