Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
Nov 06, 2024
Solved

Filter function

Dear Experts,                    Greetings! I have a data like below:- Each row has two rnti's (Col-C and Col-D), and their corresponding numofPrb are in Col-F and Col-G,   I want to prepare som...
excel
Formulas and Functions
power bi
  • Harun24HR's avatar
    Harun24HR
    Nov 06, 2024

    Try the following formula-

    =TOCOL(HSTACK(FILTER(Table3[numOfPrb-1],Table3[rnti-1]=J1),FILTER(Table3[numOfPrb-2],Table3[rnti-2]=J1)),3)

     

anupambit1797's avatar
anupambit1797
Steel Contributor
Nov 07, 2024

Hi , may I also request to share the same solution by Python in Excel?

I tried to do something like this, but getting err like "AttributeError"

 

Thanks & Regards

Anupam