cancel
Showing results for
Did you mean:
Member

## I want to create dynamic group table in power bi

Hello Experts,

I want to create dynamic group table basis my input. For example if i enter = 10, i get below table .. no. of rows are static, in this example .. rows are 15 :

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: I want to create dynamic group table in power bi

Could we do something with a couple of input tables like in the attached?  I got it to calc the low end and high end based on muliplying the group row * the selected segment.

What are you wanting to put into the groups?  # of customers based on some other measure?  What are the possible segment steps?  I put my example at 1, 2, 3, 4, 5, 10, 15, 20, 25, 50.

6 REPLIES 6
Super User III

## Re: I want to create dynamic group table in power bi

How is the input value determined? Also, how do you know how many S.No's there are going to be? Is it always 15?

Do you need this as a table, or just an output value? How are you trying to use it?

Member

## Re: I want to create dynamic group table in power bi

I have sales data, now my requirement is that if i enter segment range like 10, then first it creates groups like below (total number of groups will remain 15 always ...) , now under groups I want to show the count customers falling...

here I am unable to create dynamic range :

Super User IV

## Re: I want to create dynamic group table in power bi

Hi,

I cannot create the Groups based on a user defined interval.  However, if we can treat the Groups as a static input, i can segment the customers in the groups.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User IV

## Re: I want to create dynamic group table in power bi

Could we do something with a couple of input tables like in the attached?  I got it to calc the low end and high end based on muliplying the group row * the selected segment.

What are you wanting to put into the groups?  # of customers based on some other measure?  What are the possible segment steps?  I put my example at 1, 2, 3, 4, 5, 10, 15, 20, 25, 50.

Super User IV

## Re: I want to create dynamic group table in power bi

Hi,

May be - not sure as yet.  Will need some data to work with.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Member

## Re: I want to create dynamic group table in power bi

Thank you  @jdbuchanan71 , have the same thougts but unable to implement.... thanks a lot again

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors