Forum Discussion

ankitkdeswal's avatar
ankitkdeswal
New Member
8 years ago

Group By

Hi all.

 

I Have two Colums:

 

1. Term From

2. Term To

 

I want to filter columns ( Term From -- min ) and ( Term To -- max ) using group by

how to use group by in power BI at report level ?

 

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi ankitkdeswal,

     

    1. By which column will they be grouped? It's "Sublicense" in the attached demo.

    2. Would you like a new table or other format?

    Table =
SUMMARIZE (
    'Table1',
    Table1[Sublicense],
    "MIN", MIN ( 'Table1'[Term From] ),
    "MAX", MAX ( 'Table1'[Term To] )
)

     

    Best Regards,

    Dale