Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am tyring to map a transaction table to a mapping table that have mutliple criteria
The mapping table looks like this
The transactions table looks like this
The objective is to map the transaction based on matching all criteria in the mapping to calculate the sum (Amount_FCY) and count (# of Transaction that matches the criteria) for each row
I am trying to use Table.SelectRows but with little success unless there is an exact match,
Thanks