Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
May 09, 2025
Solved

Data extraction from Pivot

Dear Experts,                    Greetings! I have a data like below(Worksheet attached too):-  Column A(having rntis), B (having slots) and C having the transmission(DL_1_x) Out of this , fo...
BI & Data Analysis
Charting
excel
Formulas and Functions
  • PeterBartholomew1's avatar
    PeterBartholomew1
    May 12, 2025

    This is what I got from the Excel formula

    = PIVOTBY(Rnti, DCI_Slot, SIGN(ISTEXT(DCI_Info)), PERCENTOF,,0,,0,,,1)

    with a bit of conditional formatting

SergeiBaklan's avatar
SergeiBaklan
MVP
May 10, 2025

With adding data to data model we may add couple of measures

Count:=COUNTROWS( Table1 )

Mark:=VAR data =
    ADDCOLUMNS (
        Table1,
        "count", CALCULATE ( COUNTA ( Table1[DCI Info DCI Format] ) )
    )
VAR maxInRow =
    CALCULATE (
        MAXX ( VALUES ( Table1[DCI Info Slot] ), [Count] ),
        ALLEXCEPT ( Table1, Table1[Rnti] )
    )
RETURN
    IF ( [Count] < 0.7 * maxInRow, "x", "" )

PivotTable with latest shows

Resources