Forum Discussion
DAX match text in multiple columns
The new sales table would be like this:
| Brand | Date | Sales |
| Apple | Jan-19 | 2.3 |
| Apple | Jan-19 | 0.4 |
| Huawei | Jan-19 | 2.18 |
| Lenovo | Jan-19 | 0.8 |
| LG | Jan-19 | 1.1 |
| Samsung | Jan-19 | 1.9 |
| Samsung | Jan-19 | 1.3 |
| Xiaomi | Jan-19 | 1.7 |
| Apple | Feb-19 | 2.4 |
| Huawei | Feb-19 | 2.15 |
| Lenovo | Feb-19 | 0.6 |
| Lenovo | Feb-19 | 0.2 |
| LG | Feb-19 | 1.2 |
| Samsung | Feb-19 | 1.8 |
| Xiaomi | Feb-19 | 1.6 |
Hi AshleyMartinez , smpa01 ,
I believe this is the output for which you were looking... created the table that I show in the picture. Automated in PQ. Then did a join between the two tables. It is many to many, so you might want to consider an intermediate table, but it works. Here is the pbix. My pbix
I had to recreate this as I went down another road trying to set your data in a normal fashion. Exploring a table for each classification of agent would be for starters. I find if one uses a star schema from the beginning things work better down the road. You may have this, and we are only seeing a couple of tables.
How ever, I was able to rebuild it from what I had posted here. Anyway this seems to meet your requirements. Please 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
