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...
If you drop the new sales person column into the table such as "Mike" and filter out the blanks, and drop the "Mike" as a slicer you can then click on the company, and see "Mike" sales for the company.
Hope this helps your report,
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel