for each loop
1 Topic
loop through table to replace certain values? for each loop? not sure how to approach issue
Not sure how to approach this in PowerBI. If this were a normal imperative programming language, I would just write a for-each loop. I have an excel sheet of data in a Power BI report. Quote Number Winner Shop External Shop 145 Y ABC 145 N TES 145 N CAR 647 N CAR 647 Y TES 647 N ABC 785 Y ABC 546 N TES FEF There's a bunch of quote offers from different shops and sometimes even an external shop. Only one shop can win each quote. I was thinking that I could create a new column in PowerBI datasource called "Winner Name". Then what I would like to do is loop thru each quote to assign the winner instead of just displaying Y/N. For each QuoteNumber, If Winner = "Y", then for that QuoteNumber, grab Shop "ABC" and set WinnerName = ABC and If ExternalShop != blank, then WinnerName = FEF The end results I want is: Quote Number Winner Shop External Shop Winner Name 145 Y ABC ABC 145 N TES ABC 145 N CAR ABC 647 N CAR TES 647 Y TES TES 647 N ABC TES 785 Y ABC ABC 546 N TES FEF FEF I'm trying to make it so if a shop filters for their Shop name, the table on my report displays who they lost to on all of their quotes. Winner Name would immediately show them if they won or who they lost to. How do I do something like this in PowerBI?Solved902Views0likes4Comments