split query for subquery

[nirrobi]

Hi all,

I have base query as follow:

InvoiceNO;Line;Amount

INV001	1	100
INV001	2	105
INV001	3	85
INV002	1	88
INV002	2	77
INV003	1	11
INV004	1	11
INV004	2	11
INV004	3	23
INV004	4	32

I need to have different query for every invoice number

Inv001

.

.

Inv004

example Inv004:

Amount	Line	InvoiceNO
11	1	INV004
11	2	INV004
23	3	INV004
32	4	INV004

every refresh the amount of invoices can be change.

I succed to do it with 4 VAR that was manually recorded but if next refresh there will be 5 Invoices the last invoice will be missing.

is there a way to implemnt it with only variable (ommit the 4 manual variable I created)?

Thanks in advanced.

Nir.

[v-yuta-msft]

Hi nirrobi,

I succed to do it with 4 VAR that was manually recorded but if next refresh there will be 5 Invoices the last invoice will be missing.

is there a way to implemnt it with only variable (ommit the 4 manual variable I created)?

<--- Could you share the measure you are using and clarify more details about your expected result?

Regards,

Jimmy Tao

[nirrobi]

I upload the file -attaced :

https://www.dropbox.com/s/jns3lygqnj33zmw/INVOICES%20SPLIT.pbix?dl=0

I didnt use any measure , I want to use only power query.

the end result should be N/VAR new query/sheet for every invoice.

please