DAX Data Modelling

[Anonymous]

I have a list of peoples scores and the teams they reside in. What I would like to model in Power BI is how the Teams total scores change if I were to move a person from one team to another. 

For Example, this is how it would work in Excel:

With the formula in the New Total Column being: 

=IF ($I$4=K2,F2-VLOOKUP($I$3,$A$1:$C$15,3,FALSE),IF($I$5=K2,F2+VLOOKUP($I$3,$A$1:$C$15,3,FALSE),F2))

To summarise, It would take the score of the person I've selected away from their current teams total and then add their score to their new teams total.

Is there anyway I can replicate this in Power BI using DAX? I am getting stuck with how the Interactions work between the slicer (selecting the person / teams) and the tables. 

thanks!

[Anonymous]

Try using What - If parameters in powerBI.

You can create 2 parameters, one for player and another for 'into team'.

Now using DAX, create a new column called 'New/Current Team' (if statement), something like

if(Player (from underlying table) = Player (from parameter) and team (from table) != team from parameter, team(from parameter), team(from table))

Basically, for the player that is selected in parameter, we check if the team selected in parameter matches with player's actual team which is data given in underlying table. If not, we update in new column.

Now, rest of you calculations will have to be made using new team column instead of original one.

[Anonymous]

What-if parameters only lets you select numerical data types, is there a way to change it to text?