custom column fuction

[ralfvanwijk]

Hi,

I have two tables. Table A en B. 

Relevant fields in table A: 'ID number', End Date, Quantity, Price

Relevant fileds in table B: 'ID number', Custom date, Profile

In order to calculate the right Quantity times Price I need to have the Profile figure in table A.

So via custom column function in table A I tried to include Profile based on ID number and Custom Date....however it does not work... See below the function I used 

Table.SelectRows(#"GT Prfl_Fracties" , each [Kenmerk]=[Kenmerk] and [Einde levering]=[Custom date])

Somebody any I idea how I can solve this? Additional complexity. In table A not all dates are included. Some day's are missing.

Thanks for your help!

Best regards,

Ralf

[Anonymous]

Hi @ralfvanwijk ,

Did you try to merge these two tables to quotethe Custom Date? Or you may try to create a date parameter when you want to filter specified date——Parameters can be used in any query step. In addition to functioning as a data filter, parameters can be used to specify such things as a file path or a server name. Parameters don't prompt for input. Instead, you can quickly change their value using Power Query.

For more information, please refer to: Parameters | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KNP]

What do you want to happen for the rows with no dates?