Group By

[ankitkdeswal]

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 ?

[v-jiascu-msft]

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