Filtering by text within text column
Hello amazing community! Does anyone know if it is possible to create a mesure which will filter the column 'purpose' and return only those rows which contain exact wording, for example, 'design' as on the below screenshot? Many thanks for any formula suggestions! Anna
Check if rows contain a string value against an unrelated table
Hi, I have two tables in my dataset: Table1 is my transactions which have a description that looks like this: and Table2 is my legend table, where I define what each transaction belong to what category: My goal is to categorize each transaction based on the legend by looking for a piece of description column in the transaction column. So if a transaction contains "Desk", the column I'm going to create shows "Office Supplies". Here is what I've tried: I used a new custom column in Table 1 to check for 3 values and return true if they returned a value: List.Transform ( {"Desk", "Payroll", "Chair"}, (substring) => Text.Contains([Description], substring)) This returns a list of TRUE or FALSE based on the three examples I gave it. Potentially this can be used to get the first row that returns true and use that as a reference for the second column? I tried to do it in Excel, and essentially I had to use SEARCH fonction with INDEX and MATCH to get the category from a different table. My issue is that I have two tables that are not related and I'm not sure how to do a search for a piece of string for every row. I'm pretty new to PowerBI and I need some support please. TIA!DAX Measure to return the name of the largest category
Hi All() Considering I have the following column chart: Where the category in the axis is Age Range, and the values on each column are actually a measure the counts the number of a certain group of people falling in those categories (it is actually a very simple measure). I want a card that returns the category with the largest amount of people on it. Considering the chart above, the card would return "De 20 a 30". As simple as that. Any thoughts?
