1

I'm new to Power Query and I can't figure out how to do the following:

I have two tables

"REQUESTED"

Date ReqNumber Client SKU ReqQuantity
Jan-01 Z10 1 A 2
Feb-05 Z11 1 A 3

"SENT"

Date Client SKU Quantity
Jan-15 1 A 1
Feb-02 1 A 3
Mar-10 1 A 5

What I want to achieve is that I want to merfe the tables and allow me to filter by date, showing the corresponding amount requested/sent

For Example: If I filter dates between Jan-01 / Jan - 31

I should get the following:

"REQUESTED - SENT"

Date ReqNumber Client SKU ReqQuantity SentQuantity
Jan-01 Z10 1 A 2 1

If I filter dates between Jan-01 / Feb - 28

I should get the following:

"REQUESTED - SENT"

Date ReqNumber Client SKU ReqQuantity SentQuantity
Jan-01 Z10 1 A 2 2
Feb-05 Z11 1 A 3 2

If I filter dates between Jan-01 / Mar- 15

I should get the following:

"REQUESTED - SENT"

Date ReqNumber Client SKU ReqQuantity SentQuantity
Jan-01 Z10 1 A 2 2
Feb-05 Z11 1 A 3 3

Is this posiible in Power Query? Thanks!

Improve this question
3
  • Your sample data is confusing. Do you not record what the req is whenever you send product? In your sample the client requests qty 3 on 20210101, you send qty 1 on 20210115, and then qty 3 on 20210202. You sent a qty of 4 against a requested qty of 2. Commented Nov 30, 2021 at 14:50
  • Yeah, unfortunately that's actually how the warehouse works. Whenever they send a product to a client, the request number is not recorded because they can send products that where not requested or sometimes they create the new request AFTER sending some of the products, the client requested over the phone for example and sent the request a day after) Commented Nov 30, 2021 at 15:45
  • Did you like my answer? Commented May 12, 2022 at 4:38

1 Answer 1

Reset to default
1

I believe your question is a simple one that might get passed over because it is simple.

Two tables "Sent" "Requested"... Merge is under the Home tab. enter image description here Set "Requested" as Left and "Sent" as right. Select date for both. enter image description here In the Sent column click on the expand icon. enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.