Forum Discussion

gmasta1129's avatar
gmasta1129
Resolver I
1 year ago

Find Text in a column based off portfolio code

Hello,   I am looking to create a formula where it finds any text in a row and pulls the text for each row that contains the same portfolio code.    Example #1: portfolio code 545454 has 3 rows o...
Need Help
gmasta1129's avatar
gmasta1129
Resolver I
1 year ago

jgeddes , please note, column #2 is a calculated column.  My table has 30 columns and 14,300 rows. The calculated columns are not in the actual table.  A formula would work best in this scenario.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi gmasta1129 ,

     

    Calculated columns are located downstream of Powerquery; they are not visible in Powerquery. So what is the logic of the calculated column? If you want to use it in Powerquery, you need to rewrite it in Powerquery.

    Also please try this calculated column to see if it solves the problem.

    Column = CALCULATE(MAX('Table'[Interest Rate Code]),ALLEXCEPT('Table','Table'[Portfolio Code]))

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum