Using different sources of $$$ depending on the value in a field

[thomarw]

Hi there!  I have a field called 'Stage' with three different values, 'Complete', 'Execution' and 'Approved'.  If an item is 'Approved' I would like to use the value in a field called Total Project Spend, BUT if the value is 'Complete' or 'Execution' then I'd like to use the value in a field called Combined LBE.  Is there a way to apply this logic to a visualization?  Please let me know what you think.  Thanks!

[Anonymous]

Sounds like you need to create a custom column with an IF statement.  This would be something like

OutputField = IF(
	[Stage] = "Approved",
	[Total Project Spend],
	[Combined LBE]
)

This code assumes all your fields are in the same table.  If they are not, you'll need to expand on the DAX code.

[thomarw · Accepted solution]

Thanks for the guidance!  Here's what I ended up getting to work:

#"Added Custom1" = Table.AddColumn(#"Changed Type1", "NewMoney", each if [Stage] = "Approved" then [TotalProjectSpend] else [Combined LBE]),
#"Changed Type2" = Table.TransformColumnTypes(#"Added Custom1",{{"NewMoney", Currency.Type}})