DAX Case to output either Column A or Column B

[donnellyk]

Very new to DAX & expect this is quite simple

I have some currency columns in my data set that have base currency values & local currency
e.g
Haulage
Haulage_Base
TotalCost
TotalCost_base
etc

I want to create a Custom column that outputs either the local currency or base currency value based on an idSite in a related table

How I'd do this in SQL would be; 

Case if othertable.idSite in (0,1,5) then haulage_base else haluage END as CustomHaulage

I've been successfully able to pull in the vaue of the idSite from the other table to a new custom column with

Site = RELATED(othertable[idSite])

So, I thought I could us CASE as below to create my new column

CustomHaulage = (Case when RELATED(othertable[idSite] in (0,1,5) then haulage_base else haulage END)

But I just get a column full of errors & "The syntax for 'Case' is incorrect. (DAX((Case when RELATED(AuctionsSage[idSIte] in (0,1,5) then haulage_base else haulage_auction END)))."

[Greg_Deckler · Accepted solution]

@donnellyk In DAX you use SWITCH statement instead of CASE

[donnellyk]

Thanks, got it working with a SWITCH

CustomHaulage = SWITCH(
TRUE (),
RELATED(OtherTable[idSIte])="0", thistable[haulage_base],
RELATED(OtherTable[idSIte])="1", thistable[haulage_base],
RELATED(OtherTable[idSIte])="5", thistable[haulage_base],
thistable[haulage_auction]
)