Matching row from bank statement using wildcards

Hi

This is my first post here in the community and i'm pretty fresh to using Power BI.

What i'm trying to acomplish is using Power BI to get an overwiev of what and where my money goes 🙂

I have made a XLS export from my bank containing date, amount and location spent.

Problem is that the location spent often include additional info like ref number, date etc, and not only the store. I.eg "14032021 #125683 Joker Bortelid reftex" where "Joker Bortelid" is the acual store. Some times when the store name is long, this data will only contain part of the name.

To solve this i have created a reference table contain three columns: Store, chain, type.

This beeing in the example above: "Joker Bortelid"; "Joker", "Groceries"

So far so good, but now i need help to match using wildcar so that i can create visuals showing either how much i spend in each store, each chain or splitt by type.

Hope this made sense 🙂

Cheers