Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Im trying to create a new column (Opposition) based on a query that looks at the Team column and the Home & Away team and adds the Opposition based on what the Team column lists.
Team | Home Team | Away Team | Opposition |
Australia | Australia | Georgia | |
Georgia | Australia | Georgia | |
England | England | Australia | |
Australia | England | Australia | |
France | Scotland | France | |
Scotland | Scotland | France |
Solved! Go to Solution.
Perhaps:
Opposition = IF([Team] = [Home Team],[Away Team],[Home Team])
Perhaps:
Opposition = IF([Team] = [Home Team],[Away Team],[Home Team])