Date query in Powerquery

E

ErsinALACA

New Member
Joined
Mar 6, 2020
Messages
31
Office Version
  1. 2019
Platform
  1. Windows
Sorry my english is not enough. I will explain it simply;

TableA;
TableA.PNG


TableB (Wanted)
TableB.PNG


Thanks for answers.
 
Sort by date Sort by votes
maybe
TableB.DatePartPrice
13/04/2019Part A5
13/04/2019Part B6
15/06/2019Part A5.2
15/06/2019Part B6.2
17/07/2019Part A5.2
17/07/2019Part B6.3
20/12/2019Part A5.3
20/12/2019Part B6.3
 
Upvote 0

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

S
  • Solved
Checking column existence and adding column if not present
Replies
3
Views
243
sparkwoodand21
S
K
  • Solved
Can you add data to a Power Query ?
2
Replies
11
Views
547
JEC
JEC
N
  • Question
Calculating hours of working beetween start and end time but when end tim is on other row then start time and on that row has midnight as end time ?
Replies
0
Views
263
nunizgb
N
B
  • Solved
Sales dollars between two dates
Replies
3
Views
98
smozgur
smozgur
B
  • Solved
keep all data in order - power query
Replies
2
Views
101
bobaol
B

Forum statistics

Threads
1,215,890
Messages
6,127,594
Members
449,386
Latest member
owais87

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top