Forum

Thank you, Mynda. That's what I was (unfortunately) expecting!! When I create a Shape Map visual, the gradient colours for the values get automatic...

Thank you, both. I did find that Rory's solutions worked but omitted the code in column 1, but Alan's solution kept the code in column 1. I now n...

Of course!

Thank you Riny. Very interesting results. I need to get a DAX course!! I wil have a go with the large file and see how they respond. Warm regard...

Hmm. Obviously not 🙂

I've attached a file with an example source table (the original has 5m rows), a table with >1 search terms, and a table what the results would look...

Thank you, Anders. I can also see that if I remove the = sign from the inequality in Riny's solution, that I get the same result. Thank you...

Thank you, Jessica, Riny and Sunny. I am going to have to work through these to better understand how they operate. I was starting with INDIRECT bu...

Just to confirm that answer regarding the 29 million rows worked a treat. Thanks again.

Thank you, Mynda. I'll give that a try. All best wishes to you, Philip and your great team.