Date query in Powerquery

[ErsinALACA]

Sorry my english is not enough. I will explain it simply;

TableA;

TableB (Wanted)

Thanks for answers.

 

[sandy666]

Table A does not contain any date from Table B
so how do you want achieve Table B ?

maybe it will help: Google Translate

 

[ErsinALACA]

The date I will write in Table_B; It will be searched as a date range in Table_A and its equivalent will be returned. So it's not exactly a match as you mentioned.

 

[ErsinALACA]

Google çeviriyle çevirdim ► Yardımınız için öncelikle teşekkür ederim. Table_A kaynak veri; Table_B ise hedef sorgu diyelim. Table_B'de yazdığım tarih; Table_A 'da aralık olarak aranacak.

 

[ErsinALACA]

I translated it with Google translation ► First of all thank you for your help. Table_A source data; Let's say the target query is Table_B. The date I wrote in Table_B; It will be searched as a range in Table_A.

 

[sandy666]

is that what you want? (are you aware that this is a PowerBI forum?)
=INDEX(TableA[Part],MATCH([Date],TableA[Date],1))
where match_type can be: 1, 0 or -1

Date	Part	Price		Date	Part	Price
13.03.2019	Part A	5		18.03.2019	Part B	6.3
13.03.2020	Part B	6
14.03.2021	Part A	5.2
14.03.2022	Part B	6.2
18.03.2023	Part A	5.3
18.03.2024	Part B	6.3

istediğin bu mu? (bunun bir PowerBI forumu olduğunu biliyor musunuz?)
=INDEX(TableA[Part],MATCH([Date],TableA[Date],1))
burada match_type şunlar olabilir: 1, 0 veya -1

 

[sandy666]

ups, wrong tables in previous post, sorry
(önceki yazıda yanlış tablolar, üzgünüm)

Date	Part	Price		Date		Date	Part	Price
13.03.2019	Part A	5		14.03.2019		14.03.2019	Part A	5.2
13.03.2019	Part B	6				14.03.2019	Part B	6.2
14.03.2019	Part A	5.2
14.03.2019	Part B	6.2
18.03.2019	Part A	5.3
18.03.2019	Part B	6.3

// TableB
let
    Source = Excel.CurrentWorkbook(){[Name="TableB"]}[Content]
in
    Source

// TableA
let
    Source = Excel.CurrentWorkbook(){[Name="TableA"]}[Content]
in
    Source

// Merge1
let
    Source = Table.NestedJoin(TableB,{"Date"},TableA,{"Date"},"TableA",JoinKind.LeftOuter),
    #"Expanded TableA" = Table.ExpandTableColumn(Source, "TableA", {"Part", "Price"}, {"Part", "Price"})
in
    #"Expanded TableA"

 

[ErsinALACA]

The event I'm talking about is related to Excel Power Query. I don't want formulas in Excel. I guess Table statement was wrong, so you were wrong. Let Sql_A be Sql_B queries.

 

[ErsinALACA]

I'm about to leave the workplace. I will try the codes you sent. Thank you very much for your interest and help. I will report the result.

 

[sandy666]

post#7 contain proper answer (I hope) ?
(sonrası # 7 doğru cevabı içeriyor (umarım)