Forum Discussion
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...
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.