SummarizeColumns with filter comparing values of both tables

[omba]

Hi all,

I'm currently trying to create a new table that would be a join of 2 tables but with some filters based on a comparision between 1st and 2nd table columns. Let me take an example.

I currently have the 2 below tables: 

Table 1
ID	StartInt	EndInt
A	1	2
B	2	5
C	0	3
D	1	7
E	2	5

Table 2
PossibleInts
0
1
2
3
4
5
6
7
8

I would like to create a new table that would be a SummarizeColumns on Table1.[ID] and Table2.[PossibleInts] BUT with a filter so that the new row is genrated only if the Table2.[PossibleInts] is within the Table1.[StartInt] ;Table2.[StartInt] range. 
So that the result would look like something like this:

Resulting Table
ID	PossibleInts
A	1
A	2
B	2
B	3
B	4
B	5
…

Hope I was clear enough, happy to give further details if needed!

Edit: Table2 is not really needed, any solution based only on Table1 would totally suit!

Thanks in advance,
Vincent

[parry2k · Accepted solution]

@omba much easier in power query , add new custom column in power query with following M code

[StartInt]..[EndInt]

it will add a list column and now you can expand it to rows.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[omba]

Hi Parry,

Thank you very much for the quick reply, works perfectly!
I marked your reply as the solution.

Thanks again!