Customize range

[Anonymous]

Hello together,

I´ve got a little problem. I would like to have a separate row for each possibility in the Range. So from the third row there should be more lines. The result should look like this:

1 Revenue-National 80001

2 Revenue-National 80002

3 Revenue-National 80003

4 Revenue-National 80004

5 Revenue-National 80005

...

Do you know what I mean and do you can help me please 🙂

[Anonymous]

So this is my goal...

[amitchandak · Accepted solution]

@Anonymous , Try a new table like

filter(crossjoin(Table, generateseries(Min(Table[Konto Von]), Max(Table[Konto Bis]),1)), [value]>=[Konto Von] && [Value]<=[Konto Bis])