Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Nov 07, 2024

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 07, 2024

    Try the following formula-

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

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Nov 07, 2024

Try the following formula-

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

 

Resources