I know you can use the SWITCH function, or the IF Function with CONTAINSSTRING if I was to create a column (which I can't because we use direct query). I also know to get the ^ above output, I need to add some row context, but I can't identify an iterator function that would be appropriate.
Is there a solution here? or should I rebuild by using IMPORT and then add columns.
Thank you very much! Would appreciate any clear instructions as I'm a PowerBI newbie.