Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Dec 21, 2025
Solved

PivotBy or GroupBy

Dear Experts,                        Quick question,  I have a data like this from Column A~F, and want to make a data like in Col J~L So, I want a summary , that for the slot0 && txnum==1, wh...
BI & Data Analysis
excel
Formulas and Functions
power bi
  • Harun24HR's avatar
    Harun24HR
    Dec 21, 2025

    PIVOTBY() should work. Try-

    =PIVOTBY(Table1[slot],Table1[txNumber],Table1[numOfPrb],LAMBDA(x,ARRAYTOTEXT(UNIQUE(x))),0,0,,0)

    And using FILTER() function.

    =IFERROR(ARRAYTOTEXT(UNIQUE(FILTER(Table1[numOfPrb],(Table1[slot]=$L3)*(Table1[txNumber]=M$2)))),"")

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Dec 21, 2025

PIVOTBY() should work. Try-

=PIVOTBY(Table1[slot],Table1[txNumber],Table1[numOfPrb],LAMBDA(x,ARRAYTOTEXT(UNIQUE(x))),0,0,,0)

And using FILTER() function.

=IFERROR(ARRAYTOTEXT(UNIQUE(FILTER(Table1[numOfPrb],(Table1[slot]=$L3)*(Table1[txNumber]=M$2)))),"")

 

Resources