Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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