How do i set up DAX function

[Anonymous]

Hi,

how do i setup a dax formula that checks if value = Dropped in column B, then replace value "closed" in column A. If not, all values from column A should be transfered to column C.

Colum A:	Column B:		Column C (wanted result):
Closed	Dropped		Dropped
In progress	Ongoing		In progress
Monitor	Ongoing		Monitor
Closed	Actual		Closed
Closed	Implemented		Closed
New	Ongoing		New

BR Patirk

[Greg_Deckler · Accepted solution]

@Anonymous Try:

Column C = IF([Column B] = "Dropped", "Dropped", [Column A])