Forum Discussion
DAX match text in multiple columns
Hi, I've been trying to figure out how can I get this report done but I can't find any efficient way to fo it. I have 2 tables: [Table1] Sales by brand and date: Brand Date Sales Apple...
Created a column in PBI, although you would be better off in PQ, an If statement shown below. You still have some work to do,
Filter out the empty rows using the visual filter.
Let me know if you have any questions,
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Bryan = IF(Brand[City Agent] = "Bryan" || Brand[Country Agent] ="Bryan" || Brand[Head of Account] = "Bryan" || Brand[Region Agent] = "Bryan",Brand[Brand])
f
Hi Nathaniel_C , thanks for the early reply!
The thing is that my actual data base is very large, I have more than 70 sales persons and I'd like to automate the query. The problem with hardcode like typing "Bryan" in the DAX formula is that i'll have to create it 70 times for each worker.