Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
What do you want to happen for the rows with no dates?
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |