Forum Discussion

ralfvanwijk's avatar
ralfvanwijk
Regular Visitor
4 years ago

custom column fuction

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

 

 

Need Help

2 Replies

  • KNP's avatar
    KNP
    Super User
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.